List of Tables


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



Oracle Wait Interface
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
Year: 2004
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net