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

Chapter 2: Oracle Wait Interface Components

Table 2-1: Non-Idle Wait Events (Not a Complete List)

Table 2-2: Idle Wait Events (Not a Complete List)

Table 2-3: Patch Numbers for Oracle9i Database for Bug #2843192

Chapter 3: Common Wait Events

Table 3-1: buffer busy waits Reason Codes

Table 3-2: Latch Events in Oracle Database 10g

Table 3-3: Common Block Classes

Table 3-4: CPU Usage

Table 3-5: Physical I/O Requests

Chapter 4: OWI Monitoring and Collection Methods

Table 4-1: Differences Between Database Logoff Trigger and Trace Event 10046

Chapter 6: Interpreting Locks-Related Wait Events

Table 6-1: Latches vs. Locks

Table 6-2: Default Number of Hash Buckets in Select Oracle Databases

Table 6-3: ID1 and ID2 Meanings Depending on the Lock Type

Table 6-4: Lock Modes and Descriptions

Table 6-5: Lock Mode Compatibility Chart

Table 6-6: FREELIST GROUPS Effects On Segment Header Contention

Chapter 8: Wait Events in a Real Application Clusters Environment

Table 8-1: RAC Network Protocols

Table 8-2: Common Operations Causing buffer busy waits

Table 8-3: Operations Requiring CF Enqueue

Chapter 9: Performance Management in Oracle Database 10 g

Table 9-1: Metric Views (Not a Complete List)

Table 9-2: AWR Views (Not a Complete List)

Table 9-3: V$ACTIVE_SESSION_HISTORY View

Table 9-4: ADDM Views (Not a Complete List)

Appendix A: Oracle Database 10 g Diagnostic Events

Table A-1: set_ev Procedure Parameters

Table A-2: Diagnostics Event Syntax Summary

Table A-3: TRACE Supported Parameters

Table A-4: CRASH Supported Parameters

Table A-5: DEBUGGER Supported Parameters