wait events, 49 ‚ 76
buffer busy waits, 50 ‚ 51
classification of, 10
control file parallel write, 51 ‚ 53
db file parallel read, 53
db file parallel write, 53 ‚ 54
db file scattered read, 54 ‚ 55
db file sequential read, 55
db file single write, 55 ‚ 56
defining, 16
direct path read, 56 ‚ 57
direct path write, 57
enqueue, 57 ‚ 58
free buffer waits, 59
latch free, 59 ‚ 60
latency- related . See latency-related wait events
library cache lock, 61 ‚ 62
library cache pin, 60 ‚ 61
log buffer space, 62
log file parallel write, 62 ‚ 63
log file sequential read, 63
log file switch (archiving needed), 63
log file switch (checkpoint incomplete), 63 ‚ 64
log file switch completion, 64
log file sync, 64 ‚ 65
OWI versions of, 5
philosophy of, 6 ‚ 8
Real Application Clusters. See RAC (Real Application Clusters) wait events
references, 334 ‚ 335
repository, 90 ‚ 91
root cause analysis of, 79
SQL Net message to client, 65 ‚ 66
SQL*Net message from client, 65
types of, 42 ‚ 44
V$EVENT_NAME view, 19 ‚ 20
wait events, locks-related, 141 ‚ 196
buffer busy waits. See buffer busy waits wait events
enqueue waits. See enqueue wait events
latch free waits. See latch free wait events
references, 335