Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
C
C program, 327 ‚ 331
cache buffers chains latches, 159 ‚ 169
cache buffers lru chains latches, 167 ‚ 169
contention from hot blocks, 163 ‚ 166
contention from long hash chains, 166 ‚ 167
contention from SQL statements, 162 ‚ 163
defining, 58
overview of, 159 ‚ 162
Cache Fusion traffic
global cache cr request waits and, 224
interconnect used for, 224 ‚ 225
overview of, 221 ‚ 222
CACHE option, 235
cached blocks, 117
cache-hit ratio method, 3 ‚ 4, 6
CBO (Cost Based Optimizer), 279
centisecond timing, 46 ‚ 47
CF enqueue, 232 ‚ 234
change behavior events, 277 ‚ 278
checklists, troubleshooting, 7
child latches, 144, 145
CHILD_LATCH, 153
CKPT background process, 138
classes, block, 187
cleanouts, delayed block, 209 ‚ 210
Cluster file system, 216
CLUSTER_INTERCONNECTS parameter, 225
clustering factor, index, 109
collection methods . See monitoring/collection methods
commands
ALTER SESSION. See ALTER SESSION command
ALTER SESSION SET EVENTS, 157, 276, 279
ALTER SYSTEM, 304 ‚ 305, 316
ALTER SYSTEM SET <parameter>, 32
ALTER TABLE ALLOCATE EXTENT, 234
ALTER TABLE MOVE, 115
oradebug. See oradebug utility
commit frequency, log file sync events, 201 ‚ 202
components , ASH
ASHDUMP event, 258 ‚ 259
overview of, 253 ‚ 254
V$ACTIVE_SESSION_HISTORY view, 254 ‚ 257
components, OWI, 15 ‚ 48
limitations of, 45 ‚ 48
overview of, 17 ‚ 18
references for, 334 ‚ 335
trace event 10046, 30 ‚ 36
V$EVENT_HISTOGRAM view, 40 ‚ 42
V$EVENT_NAME view, 18 ‚ 20
V$SESSION_EVENT view, 24 ‚ 27
V$SESSION_WAIT view, 27 ‚ 29
V$SESSION_WAIT_CLASS view, 39 ‚ 40
V$SESSION_WAIT_HISTORY view, 37 ‚ 38
V$SYSTEM_EVENT view, 20 ‚ 24
V$SYSTEM_WAIT_CLASS view, 38 ‚ 39
wait events, defining, 16
wait events, types of, 42 ‚ 44
COMPUTE option, 116
concurrency, direct access SGA, 319
consistent get, 222
consistent read processing. See CR (consistent read) processing
"context" trace name , 283
control file, 232 ‚ 234, 309 ‚ 310
control file parallel write events, 51 ‚ 53, 138 ‚ 139
Cost Based Optimizer (CBO), 279
costs
I/O operations, 104, 120
trace event 10046 as data collector, 80
CPU statistics, 9
ADDM analysis, 261 ‚ 263, 267 ‚ 268
obtaining, 45
tracking, 72 ‚ 74
CR (consistent read) processing
Cache Fusion in, 221 ‚ 222
global cache cr request events and, 66 ‚ 67
light work rule for, 222 ‚ 223
overview of, 219
pings and false pings in, 220 ‚ 221
reducing in buffer cache, 228
reducing write complete waits latency, 132
setting _FAIRNESS_THRESHOLD in, 223
CRASH supported parameters, 284 ‚ 285
CREATE_BASELINE routine, 250 ‚ 251
CREATE_SNAPSHOT routine, 249
CU enqueue, 232
current mode (XCUR) buffer state
CR processing and, 219
global cache cr request waits and, 224
global cache wait process and, 227
CURSOR_SHARING feature, 155 ‚ 156, 232