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

Chapter 6: Interpreting Locks-Related Wait Events

Figure 6-1: A depiction of the buffer cache in Oracle8i Database and above

Chapter 9: Performance Management in Oracle Database 10 g

Figure 9-1: Workload Repository home page

Figure 9-2: Snapshots home page

Figure 9-3: Preserved Snapshot Sets (baselines) home page

Figure 9-4: Database home page top portion

Figure 9-5: Database home page bottom portion

Figure 9-6: Performance Finding Details and Recommendations

Figure 9-7: Advisor Central home page

Figure 9-8: Automatic Database Diagnostic Management

Figure 9-9: Viewing the ADDM report

Figure 9-10: Performance home page

Figure 9-11: Active Sessions Waiting: Application (wait class)

Figure 9-12: SQL Details showing SQL text and explain plan

Figure 9-13: Session Details showing general information

Figure 9-14: Session Details showing session waits