Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
McGraw-Hill Education, Jun 25, 2004 - Computers - 384 pages
Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.
1 page matching Unindexed foreign keys are no longer an issue starting in Oracle9 in this book
Results 1-1 of 1
What people are saying - Write a review
We haven't found any reviews in the usual places.
Oracle Wait Interface Components
Common Wait Events
OWI Monitoring and Collection Methods
17 other sections not shown
Other editions - View all
ADDM addr application asynchronous I/O AVERAGE_WAIT bitmap index buffer busy waits buffer cache buffers chains latch cache buffers chains centiseconds column contention enq control file CURRENT_EVENT data block Database 10g Release db file parallel db file scattered db file sequential DBWR process default diagnostic direct path read direct path write disk dump enqueue wait file parallel write file scattered read file sequential read free buffer waits full table scan hash buckets hash chains hash value instance LGWR library cache log buffer log file switch log file sync mode operations Oracle Corporation Oracle Database 10g Oracle9 oradebug Parameters Wait parameters performance PL/SQL redo log request root cause analysis session waits shared pool snapshots SQL statement statistics tablespace TIME_WAITED trace file transaction tuning v$session V$SESSION_EVENT V$SESSTAT V$SYSTEM_EVENT wait class wait event Wait Parameters Wait write wait event X$KSUSECST