Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
V
V$ views, 322
V$ACTIVE_SESSION_HISTORY view, 26 ‚ 27, 38, 252 ‚ 257
V$BH view, 228
V$CR_BLOCK_SERVER view, 221 ‚ 222, 223
V$ENQUEUE_LOCKS view, 173
V$ENQUEUE_STAT view, 177, 290 ‚ 299
V$EVENT_HISTOGRAM view, 40 ‚ 42
V$EVENT_NAME view, 18, 19 ‚ 20
V$FILESTAT view, 26, 112
V$LATCH_CHILDREN view, 152
V$LATCH_MISS view, 149
V$LOCK view, 173 ‚ 174, 180 ‚ 182
V$LOG view, 139
V$OSSTAT view, 240 ‚ 241
V$RESOURCE_LIMIT view, 231
V$SEGMENT_STATISTICS view, 180 ‚ 181, 194
V$SES_OPTIMIZER_ENV view, 109
V$SESS_TIME_MODEL view, 154, 238 ‚ 240
V$SESSION view, 28
V$SESSION_EVENT view
db file scattered reads, 113
defining, 17 ‚ 18
log file sync wait events, 199 ‚ 200
overview of, 24 ‚ 25
working with, 25 ‚ 27
V$SESSION_WAIT view
data collector in, 87 ‚ 88
defining, 17 ‚ 18
direct path writes , diagnosing, 129
overview of, 27 ‚ 29
repository tables, 90 ‚ 92
sampling frequency, 88 ‚ 90
wait event attributes displayed in, 19
X$KSUSECST starting address, 324
V$SESSION_WAIT_CLASS view, 39 ‚ 40
V$SESSION_WAIT_HISTORY view
overview of, 37 ‚ 38
past wait events viewed with, 28
V$ACTIVE_SESSION_HISTORY view vs., 252 ‚ 253
V$SESSTAT view
diagnosing direct path writes, 128 ‚ 129
redo buffer allocation retries statistic, 205
tracking CPU statistics, 9, 71 ‚ 74
V$SQL view, 107, 155
V$SQL_PLAN view, 114 ‚ 115
V$SQL_SHARED_CURSOR view, 158 ‚ 159
V$SQLAREA view, 107
V$SYSSTAT view
global cache statistics in, 227 ‚ 228
redo buffer allocation retries statistic, 205
tracking CPU statistics, 9, 71 ‚ 74
V$SYSTEM_EVENT view
buffer busy waits, 194
defining, 17 ‚ 18
discovering LGWR wait time in, 202
discovering log file sync wait events in, 199 ‚ 200
latch free wait events in, 151
overview of, 20
for system-level diagnosis, 110 ‚ 112
working with, 21 ‚ 24
V$SYSTEM_WAIT_CLASS view, 38 ‚ 39
V$WAITSTAT view, 50 ‚ 51, 192 ‚ 193
Veritas operating system, 134, 225
VMS operating system, 225