Statspack報告分析—第6部分： Wait Events - Complete list

we6100發表於2016-01-24
AI

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.

[@more@]

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章