Statspack報告分析—第6部分： Wait Events - Complete list
Statspack報告分析—第6部分： Wait Events - Complete list
The next two sections of a Statspack report show the complete list of events waited for; the first section shows events waited for by foreground processes (server processes); the second section shows events waited for by background processes (e.g. PMON); both lists include idle events, which are listed last.
The complete wait events includes the average amount of time waited for each event in milliseconds (this data is not present in the Top-5 section). Examine these sections for inordinately large waits. Also ensure no other significant events were waited for which were not be displayed in the top-5.
Idle events (such as ‘SQL*Net message to client’ and ‘smon timer’) are listed at the bottom of each section, to show that these events do not contribute to performance problems.
Statspack報告分析—第6部分： Wait Events - Complete list
The next two sections of a Statspack report show the complete list of events waited for; the first section shows events waited for by foreground processes (server processes); the second section shows events waited for by background processes (e.g. PMON); both lists include idle events, which are listed last.
The complete wait events includes the average amount of time waited for each event in milliseconds (this data is not present in the Top-5 section). Examine these sections for inordinately large waits. Also ensure no other significant events were waited for which were not be displayed in the top-5.
Idle events (such as ‘SQL*Net message to client’ and ‘smon timer’) are listed at the bottom of each section, to show that these events do not contribute to performance problems.
Wait Events for DB: WEBDB Instance: WebDB Snaps: bid -eid ->cs - centisecond - 100th of a second ->ms - millisecond - 1000th of a second (unit often used for disk IO timings) Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn ---------------------------- ------------ ---------- ----------- ----- ------ PX Deq: Execution Msg 37,855 711 340,028 90 0.1 PX Deq Credit: send blkd 19,898 167 185,763 93 0.1 PX qref latch 1,432 1,422 144,668 1010 0.0 log file parallel write 422,460 0 95,141 2 1.4 log file sync 286,685 5 62,030 2 1.0 enqueue 2,584 158 57,623 223 0.0 db file sequential read 76,476 0 54,279 7 0.3 PX Deq Credit: need buffer 7,364 46 53,559 73 0.0 db file scattered read 212,464 0 39,102 2 0.7 PX Deq: Execute Reply 7,418 0 29,766 40 0.0 PX Deq: Signal ACK 1,391 487 3,179 23 0.0 latch free 11,830 6,870 2,929 2 0.0 PX Deq: Parse Reply 823 0 2,266 28 0.0 SQL*Net break/reset to clien 2,692 0 2,045 8 0.0 db file parallel read 374 0 1,598 43 0.0 log file switch completion 83 5 1,281 154 0.0 process startup 105 0 873 83 0.0 SQL*Net message from dblink 10,526 0 806 1 0.0 control file parallel write 27,837 0 382 0 0.1 PX Deq: Join ACK 1,738 1 357 2 0.0 SQL*Net more data to client 63,373 0 300 0 0.2 log buffer space 3 2 293 977 0.0 control file sequential read 2,872 0 237 1 0.0 buffer busy waits 95 0 83 9 0.0 log file single write 244 0 81 3 0.0 file open 17,337 0 35 0 0.1 direct path read 63,950 0 31 0 0.2 refresh controlfile command 115 0 16 1 0.0 library cache pin 67 0 12 2 0.0 log file sequential read 122 0 11 1 0.0 LGWR wait for redo copy 449 6 6 0 0.0 PX Deq: Msg Fragment 12 0 6 5 0.0 db file parallel write 14,094 0 4 0 0.0 SQL*Net message to dblink 10,526 0 3 0 0.0 direct path write 5,703 0 3 0 0.0 local write wait 7 0 2 3 0.0 file identify 244 0 0 0 0.0 SQL*Net message from client 1,229,002 0 ########### 1149 4.1 PX Idle Wait 161,678 158,887 32,688,496 2022 0.5 pipe get 406 267 135,309 3333 0.0 SQL*Net more data from clien 22,385 0 31,691 14 0.1 SQL*Net message to client 1,229,012 0 390 0 4.1 ------------------------------------------------------------- Background Wait Events for DB: WEBDB Instance: WebDB Snaps: bid -eid Avg Total Wait wait Waits Event Waits Timeouts Time (cs) (ms) /txn ---------------------------- ------------ ---------- ----------- ----- ------ log file parallel write 422,460 0 95,141 2 1.4 control file parallel write 27,835 0 382 0 0.1 db file scattered read 176 0 293 17 0.0 control file sequential read 2,238 0 189 1 0.0 db file sequential read 138 0 134 10 0.0 log file single write 244 0 81 3 0.0 latch free 38 38 70 18 0.0 file open 15,738 0 24 0 0.1 log file sequential read 122 0 11 1 0.0 LGWR wait for redo copy 449 6 6 0 0.0 rdbms ipc reply 193 0 5 0 0.0 db file parallel write 14,094 0 4 0 0.0 direct path read 4,697 0 4 0 0.0 direct path write 3,477 0 2 0 0.0 file identify 244 0 0 0 0.0 buffer busy waits 3 0 0 0 0.0 rdbms ipc message 507,439 83,095 32,992,526 650 1.7 pmon timer 27,058 27,058 8,281,327 3061 0.1 smon timer 278 264 8,273,075 ##### 0.0 ------------------------------------------------------------- |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27500440/viewspace-1981444/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Statspack報告分析—第四部分：Top 5 Wait Events 5大等待事件AI事件
- statspack 報告分析
- statspack報告分析摘錄
- Statspack分析報告說明
- Statspack分析報告詳解
- Statspack分析報告詳解 (zt)
- Statspack分析報告詳解(1)
- Statspack分析報告詳解(2)
- Statspack分析報告詳解(3)
- Statspack分析報告詳解(4)
- Statspack分析報告詳解(轉)
- Statspack之六-生成分析報告
- Statspack報告分析—第一部分：資料庫資訊資料庫
- 轉：latch wait events 說明分析AI
- wait eventsAI
- Statspack報告分析—第二部分：Load Profile 負載情況負載
- 詳解statspack 報告
- Statspack報告分析—第三部分：Instance Efficiency Percentages例項效率統計
- 基於AWR實現STATSPACK報告(6-例項元件)元件
- Oracle RAC Wait EventsOracleAI
- Data Guard Wait EventsAI
- Parallel Query Wait EventsParallelAI
- statspack分析報告的日誌在什麼位置啊？
- Oracle Enqueues Wait Events 二OracleENQAI
- Oracle Enqueues Wait Events 一OracleENQAI
- Oracle Enqueues Wait Events 三OracleENQAI
- 【DATAGUARD】Data Guard Wait EventsAI
- 幾個ORACLE wait eventsOracleAI
- statspack中報告中的等待事件事件
- Code Complete部分筆記筆記
- High "Resmgr:Cpu Quantum" Wait EventsAI
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- statspack分析
- 【效能優化】Oracle 部署 Statspack並生成報告優化Oracle
- zt_關於wait events asynch descriptor resize_wait eventAI
- Buffer Cache I/O-Related Wait EventsAI
- ORACLE等待事件型別【Classes of Wait Events】Oracle事件型別AI
- 【效能最佳化】Oracle 部署 Statspack並生成報告Oracle