通过AWR获取到的数据，如何确定那些ID是需要进行分析优化的对象？
目前的SQL—ID特别多，应该找那些特征的值定义为需要分析的对象？
通过AWR报告或者监控软件获取到目前的逻辑读情况如下：
|
SQL_ID |
执行次数 |
执行时间(ms) |
物理读数 |
逻辑读数 |
每次执行时间(ms) |
每次逻辑读数 |
|
2ky7ugqrw2kxa |
35 |
237106.08 |
0 |
340651895 |
6774.46 |
9732911.29 |
|
dx4gusa8vx0cy |
3507 |
96883.68 |
25297 |
120889545 |
27.63 |
34470.93 |
|
0wu81sstgwf78 |
1004 |
117937.67 |
19994 |
38834824 |
117.47 |
38680.10 |
|
2zzy0dtc2mprt |
1312 |
45365.45 |
0 |
38471886 |
34.58 |
29323.08 |
|
d35dqcr64u97h |
358 |
35931.73 |
3 |
27938726 |
100.37 |
78041.13 |
|
dhj1qgkkzxj0q |
348 |
53327.12 |
0 |
20158602 |
153.24 |
57927.02 |
|
fjyk0c1292w5n |
7 |
12349.23 |
0 |
19873717 |
1764.18 |
2839102.43 |
|
5dqz0hqtp9fru |
764213 |
101320.84 |
4 |
18760443 |
0.13 |
24.55 |
|
3krt6sc4j2rmm |
340 |
12321.80 |
2729 |
18527261 |
36.24 |
54491.94 |
|
b2pgq46d0rhyd |
1 |
101518.49 |
1885 |
17801389 |
101518.49 |
17801389.00 |
|
7b76wyxtn6h64 |
11 |
10232.79 |
0 |
16983937 |
930.25 |
1543994.27 |
|
7bk7u0hwq8x7t |
1492 |
38387.66 |
0 |
16790996 |
25.73 |
11254.02 |
|
g8qvwvjsfpzxt |
77 |
24474.70 |
32 |
16129099 |
317.85 |
209468.82 |
|
82wzvbjpq81cx |
276 |
50382.52 |
0 |
15985433 |
182.55 |
57918.24 |
|
g5vz72zpx4ray |
16 |
8951.90 |
0 |
15601206 |
559.49 |
975075.38 |
|
c3p3z1mhauvnv |
1492 |
31147.65 |
0 |
15079644 |
20.88 |
10107.00 |
|
24aqkuka73up1 |
260 |
11140.18 |
0 |
13105424 |
42.85 |
50405.48 |
|
8jr77q08gwc69 |
2 |
8804.43 |
4916 |
12015445 |
4402.21 |
6007722.50 |
|
azwcx08pv24nj |
8938 |
13701.06 |
15286 |
11441030 |
1.53 |
1280.04 |
|
0arm6k7z9hcqm |
3 |
7156.18 |
0 |
10676826 |
2385.39 |
3558942.00 |
|
91hp5rsc126nb |
1 |
6777.27 |
0 |
9732916 |
6777.27 |
9732916.00 |
通过AWR报告或者监控软件获取到目前的物理读情况如下：
|
SQL_ID |
执行次数 |
执行时间(ms) |
物理读数 |
逻辑读数 |
每次执行时间(ms) |
每次物理读数 |
|
1f45u8ybvyhga |
1 |
11575.03 |
131747 |
709975 |
11575.03 |
131747.00 |
|
ffp2ykapzud8b |
1 |
2242.12 |
85880 |
116982 |
2242.12 |
85880.00 |
|
c2p32r5mzv8hb |
3 |
23061.39 |
57446 |
2511889 |
7687.13 |
19148.67 |
|
gv3k5zrrtx148 |
1 |
1477.06 |
33922 |
35383 |
1477.06 |
33922.00 |
|
787nbxhvpqzvz |
2 |
722.08 |
31139 |
32855 |
361.04 |
15569.50 |
|
fqx4m45zkmqu5 |
1 |
2283.44 |
27367 |
123508 |
2283.44 |
27367.00 |
|
dx4gusa8vx0cy |
3507 |
96883.68 |
25297 |
120889545 |
27.63 |
7.21 |
|
8aympm0vzxnrv |
14 |
672.12 |
23363 |
327186 |
48.01 |
1668.79 |
|
7ktxgykqnh022 |
1 |
1437.42 |
20043 |
45449 |
1437.42 |
20043.00 |
|
0wu81sstgwf78 |
1004 |
117937.67 |
19994 |
38834824 |
117.47 |
19.91 |
|
azwcx08pv24nj |
8938 |
13701.06 |
15286 |
11441030 |
1.53 |
1.71 |
|
d41v052wscuk7 |
2 |
66.63 |
14265 |
36181 |
33.32 |
7132.50 |
|
7g1ng20x8pxzk |
1 |
856.66 |
13899 |
57098 |
856.66 |
13899.00 |
|
dg90d5hvs901c |
2 |
2180.64 |
13558 |
371328 |
1090.32 |
6779.00 |
|
f076h3fcjtg00 |
37 |
1310.89 |
13165 |
487354 |
35.43 |
355.81 |
|
0nabck2ddwc61 |
530 |
8941.73 |
11130 |
163240 |
16.87 |
21.00 |
|
d8sbf0k4favca |
353 |
19751.20 |
9275 |
7437616 |
55.95 |
26.27 |
|
7shz29u32zgpf |
1 |
1054.05 |
8819 |
96156 |
1054.05 |
8819.00 |
|
cqg8179tdf1a0 |
1 |
738.48 |
8307 |
40276 |
738.48 |
8307.00 |
|
617gbhbnmp4sr |
1 |
147.91 |
7519 |
10043 |
147.91 |
7519.00 |
|
gwq6bmpzpsudj |
1 |
55.31 |
7420 |
14232 |
55.31 |
7420.00 |
|
8a0b99k6tfw7r |
2 |
707.22 |
7013 |
316877 |
353.61 |
3506.50 |
|
7g481k5mdh3rz |
1 |
381.12 |
6598 |
67175 |
381.12 |
6598.00 |
|
0ya7dbjkshh0c |
433 |
1852.97 |
6036 |
740722 |
4.28 |
13.94 |
|
1jjwct19tmqrj |
639 |
2163.22 |
5828 |
944197 |
3.39 |
9.12 |
|
b6tyvr51qtgba |
1 |
609.36 |
5700 |
47491 |
609.36 |
5700.00 |
|
dbtw08djc7vfv |
1 |
584.71 |
5549 |
23859 |
584.71 |
5549.00 |
|
1a4xrtf4jtcax |
1578 |
798.48 |
5514 |
55110 |
0.51 |
3.49 |
评论
