Index_I

I

I/O requests , tracking physical, 73 ‚ 74

I/O subsystem

free buffer waits events caused by slow, 209

log buffer space events caused by slow, 205 ‚ 206

log file sync event caused by slow, 202 ‚ 203

I/O wait events, interpreting, 103 ‚ 140

control file parallel write, 138 ‚ 139

costliness of, 120

db file parallel write, 130 ‚ 134

db file scattered read, 112 ‚ 119

db file sequential read, 104 ‚ 112

direct path read, 120 ‚ 127

direct path write, 127 ‚ 130

log file parallel write, 135 ‚ 138

references, 335

synchronous and asynchronous, 104

ID (reason code), 184, 322 ‚ 323

Idle class, 10

Idle events, 42 ‚ 43

immediate dump events, 276 ‚ 277

immediate keyword, 283

IMMEDIATE_GETS routine, latch, 145

IMMEDIATE_MISSES routine, latch, 145

index block splits , 235 ‚ 236

indexes

analyzing low ESTIMATE value, 110

analyzing with COMPUTE option, 116

db file sequential reads against, 117 ‚ 118

for foreign key columns , 183 ‚ 184

sequential reads against, 108 ‚ 110

spreading hot blocks, 166

wait for TX enqueue in mode 4, 181 ‚ 182

init.ora file

buffers dump, 306

change behavior events, 277

setting change behavior events, 277

setting diagnostic events, 279

setting multiple events, 279

setting on error dump events, 277

setting process trace events, 279

init.ora parameter, 325

initialization parameter, setting to TRUE, 17

INITRANS, 82

instance level, trace event 10046, 30

interested transaction list allocations . See ITL (interested transaction list) allocations

interval parameter values, snapshots, 248

IPC dump trace files, 322 ‚ 323

ITL (interested transaction list) allocations

TX enqueue wait in mode 4 ‚ ITL and, 179 ‚ 181

using TX enqueue, 235 ‚ 236

X$ views Transaction layer and, 320