List of Figures

1-1 Oracle Instance and Database
2-1 HR Schema
2-2 Segments, Tablespaces, and Data Files
2-3 HR Schema
2-4 External Tables
2-5 Clustered Table Data
2-6 Retrieving Data from a Hash Cluster
3-1 Internal Structure of a B-tree Index
3-2 Bitmap Join Index
3-3 Index-Organized Table
4-1 Range Partitions
4-2 List Partitions
4-3 Hash Partitions
4-4 Local Index Partitions
4-5 Global Partitioned Index
4-6 View
4-7 Materialized View
4-8 Query Rewrite
5-1 Referential Integrity Constraints
5-2 Single Table Referential Constraints
5-3 The employees Table Before Updates
5-4 Constraint Checking
7-1 Projection and Selection
7-2 Optimizer Components
7-3 Stages of SQL Processing
7-4 Shared Pool Check
7-5 Row Source Tree
8-1 Calling a PL/SQL Stored Procedure
8-2 Calling Subprograms in a PL/SQL Package
8-3 The PL/SQL Engine and Oracle Database
8-4 Two-Tier Client/Server Configuration
8-5 Java Component Structure
8-6 Main Components of Oracle JVM
8-7 Triggers
9-1 A Banking Transaction
9-2 Transaction Control Flow
10-1 Read Consistency in the Read Committed Isolation Level
10-2 Row and Table Locks
10-3 Locking Mechanisms with Unindexed Foreign Key
10-4 Locking Mechanisms with Indexed Foreign Key
11-1 Database Instance and Database Files
11-2 Oracle ASM Components
11-3 Oracle ASM Instance and Database Instances
11-4 Data Files and Tablespaces
11-5 Space in a Data File
11-6 Reuse of Online Redo Log Files
11-7 Multiple Copies of Online Redo Log Files
12-1 Logical and Physical Storage
12-2 Segments, Extents, and Data Blocks Within a Tablespace
12-3 Logical Space Management
12-4 Data Blocks and Operating System Blocks
12-5 Data Block Format
12-6 The Format of a Row Piece
12-7 ROWID Format
12-8 PCTFREE
12-9 Data Block with Fragmented Space
12-10 Data Block After Coalescing Free Space
12-11 Index Before Coalescing
12-12 Index After Coalescing
12-13 Row Chaining and Migration
12-14 Initial Extent of a Segment
12-15 Incremental Extent of a Segment
12-16 Creation of a User Segment
12-17 Multiple Segments
12-18 HWM at Table Creation
12-19 HWM and Low HWM
12-20 Advancing HWM and Low HWM
13-1 Database Instance
13-2 Database Instance Configurations
13-3 Instance and Database Startup Sequence
13-4 Instance and Database Shutdown Sequence
13-5 Checkpoint Position in Online Redo Log
13-6 Basic Instance Recovery Steps: Rolling Forward and Rolling Back
13-7 Multiple Initialization Parameter Files
13-8 ADR Directory Structure for an Oracle Database Instance
14-1 Oracle Database Memory Structures
14-2 User Global Area (UGA)
14-3 Instance PGA
14-4 PGA Contents
14-5 Database Buffer Cache
14-6 Redo Log Buffer
14-7 Shared Pool
14-8 Private SQL Areas and Shared SQL Area
14-9 Large Pool
15-1 Oracle Processes and the SGA
15-2 One Session for Each Connection
15-3 Two Sessions in One Connection
15-4 Checkpoint Process
15-5 Serial Full Table Scan
15-6 Parallel Full Table Scan
16-1 Client/Server Architecture and Distributed Processing
16-2 Client/Server Architecture and Distributed Database
16-3 A Multitier Architecture Environment
16-4 Listener Architecture
16-5 Oracle Database Using Dedicated Server Processes
16-6 The Shared Server Configuration and Processes
17-1 Common Uses for Roles
17-2 Grid Computing Environment
17-3 Architecture of a Data Warehouse
17-4 Architecture of a Data Warehouse with a Staging Area
17-5 Architecture of a Data Warehouse with a Staging Area and Data Marts
17-6 Database Link
17-7 Oracle Streams Information Flow
17-8 Oracle Streams Message Queuing
17-9 Streams Configuration
18-1 SQL*Loader Session
18-2 Oracle Data Pump Architecture
18-3 RMAN Architecture
18-4 Memory Management Methods
18-5 Automatic Memory Management
18-6 Simple Resource Plan
18-7 Scheduler Components
18-8 Automatic Workload Repository (AWR)
19-1 Application Express with Embedded PL/SQL Gateway
19-2 Program Development with Precompilers
19-3 Development Process Using OCI or OCCI
19-4 Catalog Query Application