RAC中一次混乱的性能诊断过程3
SQL ordered by Gets
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- Total Buffer Gets: 584,021,980
- Captured SQL account for 32.1% of Total
|
Buffer Gets |
Executions |
Gets per Exec |
%Total |
CPU Time (s) |
Elapsed Time (s) |
SQL Id |
SQL Module |
SQL Text |
|
17,941,301 |
10 |
1,794,130.10 |
3.07 |
60.59 |
66.10 |
|
SELECT * FROM ( Select RowNum ... | |
|
17,941,301 |
10 |
1,794,130.10 |
3.07 |
58.65 |
65.59 |
|
SELECT COUNT(*) FROM TEST1... | |
|
12,532,568 |
7 |
1,790,366.86 |
2.15 |
43.76 |
45.18 |
|
SELECT * FROM ( Select RowNum ... | |
|
12,532,548 |
7 |
1,790,364.00 |
2.15 |
43.05 |
45.91 |
|
SELECT COUNT(*) FROM TEST1... | |
|
8,932,380 |
5 |
1,786,476.00 |
1.53 |
29.04 |
31.14 |
|
SELECT COUNT(*) FROM TEST1... | |
|
8,932,379 |
5 |
1,786,475.80 |
1.53 |
29.90 |
30.93 |
|
SELECT * FROM ( Select RowNum ... | |
|
8,915,316 |
5 |
1,783,063.20 |
1.53 |
30.75 |
32.61 |
|
SELECT COUNT(*) FROM TEST1... | |
|
8,915,315 |
5 |
1,783,063.00 |
1.53 |
33.06 |
32.80 |
|
SELECT * FROM ( Select RowNum ... | |
|
8,900,709 |
5 |
1,780,141.80 |
1.52 |
29.95 |
31.08 |
|
SELECT * FROM ( Select RowNum ... | |
|
8,900,701 |
5 |
1,780,140.20 |
1.52 |
29.24 |
31.55 |
|
SELECT COUNT(*) FROM TEST1... | |
|
6,705,179 |
1 |
6,705,179.00 |
1.15 |
53.53 |
57.80 |
|
SELECT * FROM ( Select RowNum ... |
通过分析这里可能出现问题，因为SQL都是差不多或者说引用的对象都差不多，我最开始想如果能够找到方法减少这里的逻辑读，那问题一定能够改善，接着直接查看逻辑读最多的SEGMENT
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7728585/viewspace-702110/ ，如需转载，请注明出处，否则将追究法律责任。
