Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
D
Data Block Address (DBA), 219, 223 ‚ 224
data block dumps, 166, 304 ‚ 305
data blocks, buffer busy waits and, 188 ‚ 189
data source, for PL/SQL code, 87 ‚ 88
Database home page, Oracle EM Database Control, 261 ‚ 264
database logoff trigger, 82 ‚ 86
Database Response Time tuning model, 8 ‚ 11
db file parallel read events, 53
db file parallel write events, 53 ‚ 54, 130 ‚ 134
db file scattered read events, 112 ‚ 119
expensiveness of, 120
global cache cr request events and, 67
interpreting, 112 ‚ 113
monitoring, 94 ‚ 95
monitoring full table scan operations, 116 ‚ 118
overview of, 54 ‚ 55
session-level diagnosis of, 113 ‚ 116
system-level diagnosis of, 116
db file sequential read events, 104 ‚ 112
common causes, diagnosis and actions, 105 ‚ 108
expensiveness of, 120
in full table scan operations, 116 ‚ 118
global cache cr request events and, 67
against indexes, 108 ‚ 110
minimizing occurrence of, 106 ‚ 107
monitoring, 94 ‚ 95
overview of, 55
system-level diagnosis of, 110 ‚ 112
against tables, 110
db file single write events, 55 ‚ 56
DB time, 239 ‚ 240
_DB_AGING_FREEZE_CR parameter, 219
_DB_AGING_TOUCH_TIME parameter, 220
DB_BLOCK_BUFFERS parameter
buffers dump, 305
cache buffers chains latches and, 161
db file multiblock read count, 119
_DB_BLOCK_HASH_BUCKETS parameter
finding number of hash latches, 161
increasing number of hash buckets, 166
reducing hash chain length, 167
_DB_BLOCK_MAX_CR_parameter, 219
DB_BLOCK_WRITE_BATCH parameter, 132
DB_CACHE_SIZE parameter, 305
DB_FILE_DIRECT_IO_COUNT parameter, 126 ‚ 127
DB_WRITER_CHUNKS_WRITES parameter, 132
DB_WRITER_MAX_WRITES parameter, 132
DBA (Data Block Address), 219, 223 ‚ 224
DBA_EXTENTS view, 107 ‚ 108, 305
DBA_HIST_* format, 244
DBA_HIST_SNAPSHOT view, 250
DBA_INDEXES.CLUSTERING_FACTOR, 109
DBA_OBJECTS view, 108
DBIO_EXPECTED parameter, 260, 261
DBMS_ADVISOR package, 271 ‚ 273
DBMS_APPLICATION_INFO package, 34 ‚ 35
DBMS_MONITOR package, 34
DBMS_SUPPORT package, 31 ‚ 33
DBMS_SYSTEM package, 280 ‚ 281
dbms_system.read_ev package, 286
DBMS_SYSTEM.SET_EV procedure, 33
dbms_system.set_ev procedure, 279
DBMS_WORKLOAD_REPOSITORY package, 247, 250 ‚ 251
dbmssupp.sql, 32
dbmsutil.sql script, 280
DBWR processes
causing free buffer waits, 207 ‚ 210
causing log file switch (checkpoint incomplete), 212 ‚ 213
causing write complete waits, 210 ‚ 211
diagnosing db file parallel writes , 130 ‚ 134
DEBUGGER supported parameters, 284 ‚ 285
DECODE function, 20, 157
delayed block cleanouts, 209 ‚ 210
delta information, obtaining, 23
diagnostic events, 275 ‚ 287
change behavior, 277 ‚ 278
on error dump, 277
immediate dump, 276 ‚ 277
internal workings of, 285 ‚ 287
multiple actions for, 284 ‚ 285
process trace, 278 ‚ 279
references for, 337
setting, 279 ‚ 281
syntax for, 282 ‚ 284
wait events vs., 16
dictionary cache, 71 ‚ 72
direct access SGA. See SGA Direct Access
direct path read events, 120 ‚ 127
diagnosing, 120 ‚ 121
initialization parameters, 126 ‚ 127
monitoring, 95 ‚ 96
overview of, 56 ‚ 57
session-level diagnosis of, 121 ‚ 126
direct path write events
diagnosing, 128 ‚ 130
monitoring, 96 ‚ 97
overview of, 57
DISK_ASYNCH_IO parameter, 133 ‚ 134
DISK_READS column, 107
DLM (Distributed Lock Manager), 220 ‚ 221
DML, performing on X$ views, 322
documentation, OWI, 6
DROP_BASELINE procedure, 251
DROP_SNAPSHOT_RANGE procedure, 249
dumps and traces, 301 ‚ 316
buffer dumps, 307 ‚ 308
buffers dumps, 305 ‚ 306
control file dumps, 309 ‚ 310
controlling buffers dump information, 306
data block dumps, 304 ‚ 305
file headers dumps, 308 ‚ 309
heap dumps, 310 ‚ 312
library cache dumps, 312 ‚ 313
processstate dumps, 313
redo log dumps, 315 ‚ 316
references, 337
setting with oradebug utility, 302 ‚ 304
shared server state dumps, 314
systemstate dumps, 315
dynamic remastering , 218