Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

O

object name resolution, 107 ‚ 108

OLTP databases, log file sync events, 202

ON DELETE CASCADE option, 183

operating system statistics, 240 ‚ 241

OPS (Oracle Parallel Server), 220

optimizer, 109

OPTIMIZER_INDEX_COST_ADJ parameter, 109

OPTIMIZER_INDEX_COST_CACHING parameter, 109

ORA-01555 (snapshot too old) error, 201

Oracle Database 10 g , 237 ‚ 274

Active Session History. See ASH (Active Session History)

Automatic Database Diagnostic Monitor. See ADDM (Automatic Database Diagnostic Monitor)

Automatic Workload Repository. See AWR (Automatic Workload Repository)

buffer busy wait codes in, 186

database statistics, 238 ‚ 241

discovering SQL statement, 107

latch free wait events in, 142, 149 ‚ 150

new background processes, 241 ‚ 242

RAC environment and, 230 ‚ 231

references, 336

Oracle Parallel Server (OPS), 220

Oracle Partitioning, 243

Oracle SNP, 88

Oracle Wait Interface. See OWI (Oracle Wait Interface), overview

oradebug utility

buffer dump, 307

buffers dump, 306

commands, 302 ‚ 304

control file dumps, 310

dump events command, 286 ‚ 287

file headers dumps, 308

finding trace file, 35

heap dumps, 311

library cache dumps, 312

not using for block dumps, 305

obtaining SGA ID through, 322 ‚ 323

processstate dumps, 313

setting diagnostic events, 279

setting events with, 281

shared server state dumps, 314

systemstate dumps, 315

tracing someone else ‚ s session, 33

triggering immediate dumps with, 276

ORAPID number, 287

OTHER_WAIT column, 229

overhead

always-on and low, 80

database logoff trigger and, 82

direct access SGA and, 318

high commit frequencies causing , 201

OWI (Oracle Wait Interface), overview, 1 ‚ 13

cache-hit ratios, 3 ‚ 5

Database Response Time tuning model, 8 ‚ 11

introduction, 2

limitations, 45 ‚ 48

performance optimization, 3, 5 ‚ 6

philosophy of, 6 ‚ 8

references, 334 ‚ 335

response time perspective, 11 ‚ 13