List of Figures

2-1 The Relationships Among Segments, Extents, and Data Blocks

2-2 Data Block Format

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 Types of Possible Dependent and Referenced Schema Objects

6-2 Indirect Dependencies

8-1 Oracle Memory Structures

9-1 An Oracle Instance

9-2 Background Processes of a Multiple-Process Oracle Instance

9-3 The Shared Server Configuration and Processes

9-4 Oracle Using Dedicated Server Processes

10-1 The Client/Server Architecture and Distributed Processing

10-2 A Multitier Architecture Environment Example

12-1 An Oracle Instance

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

15-3 Basic Recovery Steps: Rolling Forward and Rolling Back

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

18-1 A View of Partitioned Tables

18-2 List, Range, and Hash Partitioning

18-3 Composite Partitioning

18-4 Composite Range-Hash Partitioning

18-5 Composite Range-List Partitioning

18-6 Local Partitioned Index

18-7 Global Partitioned Index

18-8 Global Nonpartitioned Index

20-1 Database Administrator Authentication Methods

20-2 Common Uses for Roles

21-1 Examples of Data Integrity

21-2 NOT NULL Integrity Constraints

21-3 A UNIQUE Key Constraint

21-4 A Composite UNIQUE Key Constraint

21-5 A Primary Key Constraint

21-6 Referential Integrity Constraints

21-7 Single Table Referential Constraints

21-8 Locking Mechanisms When No Index Is Defined on the Foreign Key

21-9 Locking Mechanisms When Index Is Defined on the Foreign Key

21-10 The EMP Table Before Updates

21-11 Constraint Checking

22-2 Cascading Triggers

22-3 The REORDER Trigger

23-1 Streams Information Flow

23-2 Streams Configuration

24-1 The Stages in Processing a SQL Statement

24-2 The PL/SQL Engine and the Oracle Database Server

24-3 Stored Procedure

24-4 A Stored Package

24-5 Classes and Instances

24-6 Using Inheritance to Localize Behavior and State

24-7 Java Component Structure

24-8 Java Component Structure

27-1 A Type Hierarchy

27-2 Multiple View Hierarchies