List of Figures

• 2-1 The Relationships Among Segments, Extents, and Data Blocks
• 2-2 Data Block Format
• 2-3 PCTFREE
• 2-4 PCTUSED
• 2-5 Maintaining the Free Space of Data Blocks with PCTFREE and PCTUSED
• 3-1 Datafiles and Tablespaces
• 3-2 Enlarging a Database by Adding a Datafile to a Tablespace
• 3-3 Enlarging a Database by Adding a New Tablespace
• 3-4 Enlarging a Database by Dynamically Sizing Datafiles
• 4-1 A Banking Transaction
• 5-1 Schema Objects, Tablespaces, and Datafiles
• 5-2 The EMP Table
• 5-3 The Format of a Row Piece
• 5-4 DEFAULT Column Values
• 5-5 An Example of a View
• 5-6 Composite Index Example
• 5-7 Internal Structure of a B-tree Index
• 5-8 Running a Query Using Bitmap Indexes
• 5-9 Structure of a Regular Table Compared with an Index-Organized Table
• 5-10 Clustered Table Data
• 6-1 Dependency Relationships
• 8-1 Oracle Database Memory Structures
• 9-1 An Oracle Database Instance
• 9-2 Background Processes of a Multiple-Process Oracle Database Instance
• 9-3 The Shared Server Configuration and Processes
• 9-4 Oracle Database Using Dedicated Server Processes
• 9-5 Pool of Dedicated Server Processes Handling Connections Through the Connection Broker Process
• 10-1 The Client/Server Architecture and Distributed Processing
• 10-2 A Multitier Architecture Environment Example
• 12-1 An Oracle Instance
• 12-2 Basic Recovery Steps: Rolling Forward and Rolling Back
• 13-1 Transactions and Read Consistency
• 13-2 Serializable Transaction Failure
• 13-3 Two Transactions in a Deadlock
• 15-1 Whole Database Backup Options
• 15-2 Media Recovery
• 16-1 Architecture of a Data Warehouse
• 16-2 Architecture of a Data Warehouse with a Staging Area
• 16-3 Architecture of a Data Warehouse with a Staging Area and Data Marts
• 16-4 Pipelined Data Transformation
• 16-5 Serial Full Table Scan
• 16-6 Parallel Full Table Scan
• 17-1 Causes of Downtime
• 17-2 Downtime Due to Data Failures
• 17-3 Downtime Due to Data Changes
• 20-1 Common Uses for Roles
• 21-1 Referential Integrity Constraints
• 21-2 Single Table Referential Constraints
• 21-3 Locking Mechanisms When No Index Is Defined on the Foreign Key
• 21-4 Locking Mechanisms When Index Is Defined on the Foreign Key
• 21-5 The EMP Table Before Updates
• 21-6 Constraint Checking
• 22-1 Triggers
• 22-2 The REORDER Trigger
• 23-1 Streams Information Flow
• 23-2 Streams Configuration
• 24-1 The Stages in Processing a SQL Statement
• 25-1 The PL/SQL Engine and Oracle Database
• 25-2 Stored Procedure
• 25-3 A Stored Package
• 25-4 Classes and Instances
• 25-5 Using Inheritance to Localize Behavior and State
• 25-6 Java Component Structure
• 25-7 Java Component Structure