Index_V

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