|
SQL ordered by CPU Time
• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
•Captured SQL account for 83.0% of Total CPU Time (s): 9,240
•Captured PL/SQL account for 0.0% of Total CPU Time (s): 9,240
CPU Time (s)
Executions
CPU per Exec (s)
%Total
Elapsed Time (s)
%CPU
%IO
SQL Id
SQL Module
SQL Text
2,390.23 10,719 0.22 25.87 15,434.99 15.49 0.00 bbjh8y6nbzrvx select aa.id, aa.title, aa.con...
1,750.89 10,704 0.16 18.95 12,280.97 14.26 0.00 78nftn2bahtvt select * from ( select aa.id, ...
1,220.76 5,587 0.22 13.21 7,623.18 16.01 0.00 00rxjzvf46mjn select aa.id, aa.title, aa.con...
901.85 5,578 0.16 9.76 6,119.31 14.74 0.00 1yn1kkk806cs9 select * from ( select aa.id, ...
225.98 3,589 0.06 2.45 1,161.12 19.46 0.00 gq754q2k2ba00 select tsurfmodul0_.id as id0_...
216.87 170 1.28 2.35 1,237.11 17.53 0.00 72x7sb99y9a47 select count(t.business_id) nu...
139.78 4,662 0.03 1.51 581.22 24.05 0.00 73mu0ta89hpza select tsurfmodul0_.id as id12...
109.35 1,435,837 0.00 1.18 616.80 17.73 0.00 20g72xjs4fuwn select tsurfmodul0_.id as id12...
108.05 473 0.23 1.17 601.76 17.96 0.00 1pdyhb9xhuh94 select aa.id, aa.title, aa.con...
80.05 474 0.17 0.87 484.93 16.51 0.00 8386sfuwkbvvw select * from ( select aa.id, ...
归根结底,还是这些SQL的问题,调SQL吧。 |
|