List of Figures

2-1 N-tier Architecture Middleware Components and Real Application Clusters

2-2 Disk Affinity Example

4-1 Node Affinity for Transactions Against Tables Partitioned by Range

6-1 Cache Fusion Ships Blocks from Cache to Cache Across the Interconnect

7-1 Expanding Charts

A-1 Mapping Locks to Data Blocks

A-2 GC_FILES_TO_LOCKS Example 5

A-3 GC_FILES_TO_LOCKS Example 6

A-4 GC_FILES_TO_LOCKS Example 7

A-5 GC_FILES_TO_LOCKS Example 8

A-6 A File with a High Water Mark That Moves as Oracle Allocates Blocks

A-7 Allocating Blocks within An Extent

A-8 Extents and Free List Groups

B-1 Number of I/Os for Each SELECT or INSERT Operation

B-2 Case Study: Partitioning Users and Data

B-3 Case Study: Partitioning Users and Data: Design Option 1

B-4 Case Study: Partitioning Users and Data: Design Option 2