List of Figures

• 1-1 Example of an Oracle Database Release Number
• 1-2 Database Administrator Authentication Methods
• 5-1 Oracle Database Dedicated Server Processes
• 5-2 Oracle Database Shared Server Processes
• 6-1 Oracle Database Memory Structures
• 9-1 Product/Component Type Subdirectories in the ADR
• 9-2 ADR Directory Structure for a Database Instance
• 9-3 Workflow for Investigating, Reporting, and Resolving a Problem
• 9-4 Alerts Section of the Database Home Page
• 9-5 Enterprise Manager Support Workbench Home Page
• 9-6 Select Package Page
• 9-7 Customize Package Page
• 9-8 Copy Out Files Page
• 9-9 Files Subpage of Customize Package Page
• 11-1 Reuse of Redo Log Files by LGWR
• 11-2 Multiplexed Redo Log Files
• 11-3 Legal and Illegal Multiplexed Redo Log Configuration
• 12-1 Redo Log File Use in ARCHIVELOG Mode
• 14-1 Components of File Mapping
• 14-2 Illustration of Mapping Structures
• 18-1 Tables page
• 18-2 Advisor Central page
• 18-3 Segment Advisor Recommendations page
• 18-4 Recommendation Details page
• 20-1 Coalescing Indexes
• 21-1 Clustered Table Data
• 26-1 A Simple Resource Plan
• 26-2 A Resource Plan With Subplans
• 26-3 Multilevel Plan Schema
• 27-1 Chain with Multiple Branches
• 27-2 Windows help define the resources that are allocated to jobs
• 27-3 Windows and Resource Plans (Example 1)
• 27-4 Windows and Resource Plans (Example 2)
• 27-5 Relationships Among Programs, Jobs, and Schedules
• 27-6 Scheduler Components
• 27-7 RAC Architecture and the Scheduler
• 27-8 Service Affinity and the Scheduler
• 28-1 Chain with Step 3 Paused
• 28-2 Sample Resource Plan
• 30-1 Homogeneous Distributed Database
• 30-2 An Oracle Database Distributed Database System
• 30-3 Database Link
• 30-4 Hierarchical Arrangement of Networked Databases
• 30-5 Global User Security
• 30-6 NLS Parameter Settings in a Client/Server Environment
• 30-7 NLS Parameter Settings in a Homogeneous Environment
• 30-8 NLS Parameter Settings in a Heterogeneous Environment
• 31-1 A Shared Database Link to Dedicated Server Processes
• 31-2 Shared Database Link to Shared Server
• 31-3 Views and Location Transparency
• 33-1 Distributed System
• 33-2 Example of a Session Tree
• 33-3 Commit Point Site
• 33-4 Commit Point Strengths and Determination of the Commit Point Site
• 33-5 Failure During Prepare Phase
• 33-6 Failure During Commit Phase
• 33-7 Defining the Session Tree
• 33-8 Determining the Commit Point Site
• 33-9 Sending and Acknowledging the Prepare Message
• 33-10 Instructing Nodes to Commit
• 34-1 Example of an In-Doubt Distributed Transaction