Index_C

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