List of Figures

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