Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

W

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

wait model statistics, 240

wait time, 9, 47

WAIT_CLASS, 19 ‚ 20

WAIT_CLASS ID, 19 ‚ 20

WAIT_CLASS#, 19 ‚ 20

WAIT_COUNT column, 37, 41 ‚ 42

_WAIT_FOR_SYNC parameter, 198 ‚ 199

WAIT_TIME column, 27 ‚ 28

WAIT_TIME_MILLI column, 40 ‚ 42

willing-to-wait mode, latches, 145 ‚ 146

WRH$, 243

WRI$, 243

write complete waits wait event

causes of, 210 ‚ 211

overview of, 131 ‚ 133

WRM$, 243