List of Tables

3-1 Example of Overlapping Tables

3-2 Example of Table Access Types

3-3 Example of Table Transaction Volumes

5-1 Memory Trace Files and Their Locations

5-2 Statistics and their Classes in V$SYSSTAT

5-3 Global Cache Coherency and Contention Views and Their Statistics

7-1 Performance Charts

A-1 When to Use Pre-Release 1 (9.0.1) Locks

A-2 Interpreting the Forced Write Rate

A-3 Pre-Release 1 (9.0.1) Locks Types and Names

B-1 Eddie Bean Sample Tables

B-2 Table Access Analysis Worksheet

B-3 Number of I/Os for each Operation: Sample ORDER_HEADER Table

B-4 Number of I/Os for each Operation: Other Sample Tables

B-5 Case Study: Table Access Analysis Worksheet

B-6 Transaction Volume Analysis Worksheet

B-7 Case Study: Transaction Volume Analysis: ORDER_HEADER Table

B-8 Case Study: Transaction Volume Analysis: ORDER_ITEM Table

B-9 Case Study: Transaction Volume Analysis: ACCOUNTS_PAYABLE Table