Index_D

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