分析:
Top 10 Foreground Events by Total Wait Time
Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class DB CPU 9239.6 14.9 reliable message 1,175,583 3924.9 3 6.3 Other db file sequential read 429,967 1844.8 4 3.0 User I/O SQL*Net more data to client 8,947,769 838.2 0 1.3 Network log file sync 195,677 436.8 2 .7 Commit gc current block 2-way 433,667 331.9 1 .5 Cluster db file parallel read 40,693 260.8 6 .4 User I/O gc cr block 2-way 137,863 125.1 1 .2 Cluster SQL*Net message to client 32,641,422 99.9 0 .2 Network gc current block busy 28,184 80.6 3 .1 ClusterV$SYS_TIME_MODEL
Table 9-1 V$SESS_TIME_MODEL and V$SYS_TIME_MODEL Statistics
Statistic Name DescriptionAmount of elapsed time (in microseconds) consumed by database background processes.
Amount of CPU time (in microseconds) consumed by database background processes.
Amount of elapsed time spent parsing SQL statements. It includes both soft and hard parse time.
Amount of elapsed time spent hard parsing SQL statements.
connection management call elapsed time
Amount of elapsed time spent performing session connect and disconnect calls.
Amount of time spent performing SQL parses which ultimately fail with some parse error.
failed parse (out of shared memory) elapsed time
Amount of time spent performing SQL parses which ultimately fail with error ORA-04031.
hard parse (sharing criteria) elapsed time
hard parse (bind mismatch) elapsed time
PL/SQL compilation elapsed time
Amount of elapsed time spent running the PL/SQL compiler.
inbound PL/SQL rpc elapsed time
RMAN cpu time (backup/restore)
Amount of CPU time (in microseconds) spent in RMAN backup and restore operations.
Amount of elapsed time spent giving new values to bind variables (rebinding).
1) background elapsed time 2) background cpu time 3) RMAN cpu time (backup/restore) 1) DB time 2) DB CPU 2) connection management call elapsed time 2) sequence load elapsed time 2) sql execute elapsed time 2) parse time elapsed 3) hard parse elapsed time 4) hard parse (sharing criteria) elapsed time 5) hard parse (bind mismatch) elapsed time 3) failed parse elapsed time 4) failed parse (out of shared memory) elapsed time 2) PL/SQL execution elapsed time 2) inbound PL/SQL rpc elapsed time 2) PL/SQL compilation elapsed time 2) Java execution elapsed time 2) repeated bind elapsed time
Children do not necessarily add up to the parent.(子项不一定会累加到父项)
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 - Elapsed Time as a percentage of Total DB time %CPU - CPU Time as a percentage of Elapsed Time %IO - User I/O Time as a percentage of Elapsed Time Captured SQL account for 82.7% of Total DB Time (s): 62,166 Captured PL/SQL account for 0.0% of Total DB Time (s): 62,166 Elapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text 15,434.99 10,719 1.44 24.83 15.49 0.00 select , aa.title, aa.con... 12,280.97 10,704 1.15 19.76 14.26 0.00 select * from ( select , ... 7,623.18 5,587 1.36 12.26 16.01 0.00 select , aa.title, aa.con... 6,119.31 5,578 1.10 9.84 14.74 0.00 select * from ( select , ... 1,237.11 170 7.28 1.99 17.53 0.00 select count(t.business_id) nu... 1,161.12 3,589 0.32 1.87 19.46 0.00 select as id0_... 912.41 119,289 0.01 1.47 2.46 84.38 select as id4_... 616.80 1,435,837 0.00 0.99 17.73 0.00 select as id12... 601.76 473 1.27 0.97 17.96 0.00 select , aa.title, aa.con... 581.22 4,662 0.12 0.93 24.05 0.00 select as id12...How to Interpret the OS stats section of an AWR report (文档 ID 762526.1)
AWR Report Shows Huge Numbers For Av/Rd (文档 ID 465106.1)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-1252817/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-1252817/