Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
McGraw Hill Professional, 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.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Oracle Wait Interface Components
Common Wait Events
11 other sections not shown
acetaminophen Allergies application asynchronous I/O AVERAGE_WAIT baby bottlenecks buffer busy waits buffer cache busy waits cache buffers chains Call Your Doctor centiseconds Chapter child column control file cough CURRENT_EVENT Database 10g Release db file parallel db file scattered db file sequential DBAs DBWR Diagnostics & Tuning diarrhea direct path read direct path write disk fever file parallel write file scattered read file sequential read global cache Guide to Performance hash buckets hash chains hash value Home Care Tips ibuprofen infection latch free LGWR process library cache lock medicine mode monitor operation Oracle Corporation Oracle Database 10g Oracle Wait Interface Oracle9 pain Parameters Wait parameters parse Performance Diagnostics PL/SQL Practical Guide rash read event read wait event root cause analysis shared pool SQL statement statistics symptoms tablespace TIME_WAITED trace event 10046 trace file v$session V$SYSTEM_EVENT vomiting wait class wait event Wait Parameters Wait