RAC中一次混乱的性能诊断过程2
SQL ordered by Elapsed Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
- Total DB Time (s): 5,870
- Captured SQL account for 16.7% of Total
|
Elapsed Time (s) |
CPU Time (s) |
Executions |
Elap per Exec (s) |
% Total DB Time |
SQL Id |
SQL Module |
SQL Text |
|
66 |
61 |
10 |
6.61 |
1.13 |
|
SELECT * FROM ( Select RowNum ... | |
|
66 |
59 |
10 |
6.56 |
1.12 |
|
SELECT COUNT(*) FROM TEST1... | |
|
58 |
54 |
1 |
57.80 |
0.98 |
|
SELECT * FROM ( Select RowNum ... | |
|
46 |
43 |
7 |
6.56 |
0.78 |
|
SELECT COUNT(*) FROM TEST1 ... | |
|
45 |
44 |
7 |
6.45 |
0.77 |
|
SELECT * FROM ( Select RowNum ... | |
|
37 |
25 |
3 |
12.24 |
0.63 |
|
select ti.serialno itemNo, ti.... | |
|
33 |
33 |
5 |
6.56 |
0.56 |
|
SELECT * FROM ( Select RowNum ... | |
|
33 |
31 |
5 |
6.52 |
0.56 |
|
SELECT COUNT(*) FROM TEST1 ... | |
|
32 |
29 |
58 |
0.55 |
0.54 |
|
SELECT DISTINCT Wflog.* FROM W... | |
|
32 |
29 |
5 |
6.31 |
0.54 |
|
SELECT COUNT(*) FROM TEST1 ... |
结果可以看到基本没有特别耗时的SQL，所以想通过优化单个SQL来大幅度提高性能的想法是不能实现的，然后进入查看最多逻辑读取的SQL
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7728585/viewspace-702109/ ，如需转载，请注明出处，否则将追究法律责任。
