Oracle - AWR - 教你如何看 - 图文(3)

? ? ? ? ? ? ? Time Model Statistics Wait Class Wait Events Background Wait Events Operating System Statistics Service Statistics Service Wait Class Stats Back to Top

Time Model Statistics

? ? ?

Total time in database user-calls (DB Time): 663s

Statistics including the word \contribute to the DB time statistic

Ordered by % or DB time desc, Statistic name Statistic Name DB CPU sql execute elapsed time parse time elapsed PL/SQL execution elapsed time hard parse elapsed time connection management call elapsed time hard parse (sharing criteria) elapsed time repeated bind elapsed time PL/SQL compilation elapsed time failed parse elapsed time DB time background elapsed time background cpu time Time (s) % of DB Time 514.50 482.27 3.76 0.50 0.34 0.08 0.00 0.00 0.00 0.00 662.97 185.19 67.48 77.61 72.74 0.57 0.08 0.05 0.01 0.00 0.00 0.00 0.00 此节显示了各种类型的数据库处理任务所占用的CPU时间。

Back to Wait Events Statistics Back to Top

Wait Class

? ? ? ? ?

s - second

cs - centisecond - 100th of a second ms - millisecond - 1000th of a second

us - microsecond - 1000000th of a second ordered by wait time desc, waits desc

Waits 66,837 28,295 1,571,450 210,548 81,783 333,155 5,182 919 25,427 %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn 0.00 0.00 0.00 0.00 71.82 0.00 0.04 0.00 99.46 120 93 66 29 28 16 5 4 1 2 3 0 0 0 0 1 4 0 11.94 5.05 280.72 37.61 14.61 59.51 0.93 0.16 4.54 Wait Class User I/O System I/O Network Cluster Other Application Concurrency Commit Configuration Back to Wait Events Statistics Back to Top

Wait Events

? ? ? ? ?

s - second

cs - centisecond - 100th of a second ms - millisecond - 1000th of a second

us - microsecond - 1000000th of a second

ordered by wait time desc, waits desc (idle events last)

%Time -outs 0.00 0.00 0.00 0.00 0.00 0.00 2.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total Wait Time (s) 64 47 35 34 31 30 18 16 13 10 10 9 8 4 3 3 3 3 2 2 Avg wait (ms) 2 9 4 7 3 1 49 0 4 0 1 5 0 4 6 0 1 1 0 4 Waits /txn 4.88 0.98 1.41 0.86 1.84 7.63 0.06 59.50 0.67 31.39 2.85 0.33 3.73 0.16 0.09 1.85 0.63 0.35 0.74 0.08 Event SQL*Net more data from client log file parallel write db file sequential read db file parallel write db file scattered read direct path write reliable message SQL*Net break/reset to client db file parallel read gc current multi block request control file sequential read direct path read temp gc cr multi block request log file sync gc cr block busy enq: FB - contention DFS lock handle control file parallel write gc current block 2-way library cache lock Waits 27,319 5,497 7,900 4,806 10,310 42,724 355 333,084 3,732 175,710 15,974 1,873 20,877 919 526 10,384 3,517 1,946 4,165 432 name-service call wait row cache lock gcs log flush sync os thread startup gc cr block 2-way gc current block busy SQL*Net message to client gc buffer busy gc cr disk read direct path write temp gc current grant busy log file switch completion CGS wait for IPC msg gc current grant 2-way kjbdrmcvtq lmon drm quiesce: ping completion enq: US - contention direct path read enq: WF - contention ksxr poll remote instances library cache pin ges global resource directory to be frozen wait for scn ack log file sequential read undo segment extension rdbms ipc reply ktfbtgex enq: HW - contention gc cr grant 2-way enq: TX - index contention enq: CF - contention PX Deq: Signal ACK latch free buffer busy waits KJC: Wait for msg sends to complete log buffer space enq: PS - contention enq: TM - contention IPC send completion sync PX Deq: reap credit log file single write enq: TT - contention enq: TD - KTF dump entries read by other session LGWR wait for redo copy PX Deq Credit: send blkd enq: TA - contention latch: ges resource hash list enq: PI - contention write complete waits enq: DR - contention 22 3,894 1,259 18 3,671 113 1,544,115 15 3,272 159 898 29 48,739 1,142 9 567 138 14 13,291 211 9 583 36 25,342 279 6 44 158 1 64 37 3 625 154 11 46 70 40 1,544 36 46 12 1 540 17 14 44 8 1 3 0.00 0.00 42.02 5.56 0.00 0.00 0.00 6.67 0.00 0.00 0.00 0.00 99.87 0.00 0.00 0.00 0.00 0.00 58.45 0.00 100.00 0.00 0.00 99.79 0.00 100.00 0.00 0.00 0.00 0.00 21.62 0.00 0.16 0.00 0.00 0.00 0.00 100.00 99.81 0.00 0.00 0.00 0.00 0.00 5.88 0.00 0.00 0.00 0.00 0.00 2 2 2 2 2 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76 0 1 89 0 12 0 70 0 5 1 17 0 0 19 0 1 9 0 1 10 0 2 0 0 10 1 0 34 1 1 10 0 0 2 1 0 0 0 0 0 1 12 0 0 0 0 0 2 0 0.00 0.70 0.22 0.00 0.66 0.02 275.83 0.00 0.58 0.03 0.16 0.01 8.71 0.20 0.00 0.10 0.02 0.00 2.37 0.04 0.00 0.10 0.01 4.53 0.05 0.00 0.01 0.03 0.00 0.01 0.01 0.00 0.11 0.03 0.00 0.01 0.01 0.01 0.28 0.01 0.01 0.00 0.00 0.10 0.00 0.00 0.01 0.00 0.00 0.00 enq: MW - contention enq: TS - contention PX qref latch enq: MD - contention latch: KCL gc element parent latch enq: JS - job run lock - synchronize SQL*Net more data to client latch: cache buffers lru chain enq: UL - contention gc current split enq: AF - task serialization latch: object queue header operation latch: cache buffers chains latch: enqueue hash chains SQL*Net message from client gcs remote message DIAG idle wait ges remote message Streams AQ: qmn slave idle wait Streams AQ: qmn coordinator idle wait Streams AQ: waiting for messages in the queue virtual circuit status PX Idle Wait jobq slave wait Streams AQ: waiting for time management or cleanup tasks PX Deq: Parse Reply PX Deq: Execution Msg PX Deq: Join ACK PX Deq: Execute Reply PX Deq: Msg Fragment Streams AQ: RAC qmn coordinator idle wait class slave wait 3 3 150 2 11 1 16 1 1 1 1 3 1 2 1,544,113 634,884 23,628 149,591 167 351 488 157 1,072 145 1 40 121 38 34 16 351 2 0.00 0.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 98.64 0.00 93.45 0.00 47.86 100.00 100.00 97.11 97.93 100.00 40.00 26.45 42.11 32.35 0.00 100.00 0.00 0 0 0 0 …… 此处隐藏：4817字，全部文档内容请下载后查看。喜欢就下载吧 ……