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
• 10-1 Directory Structure in the Management Service Home for Release 11g or Later
• 10-2 Directory Structure in the Management Home for Release 10g
• 12-1 Reuse of Redo Log Files by LGWR
• 12-2 Multiplexed Redo Log Files
• 12-3 Legal and Illegal Multiplexed Redo Log Configuration
• 13-1 Redo Log File Use in ARCHIVELOG Mode
• 15-1 Components of File Mapping
• 15-2 Illustration of Mapping Structures
• 19-1 Tables page
• 19-2 Advisor Central page
• 19-3 Segment Advisor Recommendations page
• 19-4 Recommendation Details page
• 21-1 Coalescing Indexes
• 22-1 Clustered Table Data
• 27-1 A Simple Resource Plan
• 27-2 A Resource Plan With Subplans
• 27-3 Multilevel Plan Schema
• 27-4 Resource Plan with Maximum Utilization for Subplan and Consumer Groups
• 28-1 Chain with Multiple Branches
• 28-2 Windows help define the resources that are allocated to jobs
• 28-3 Windows and Resource Plans (Example 1)
• 28-4 Windows and Resource Plans (Example 2)
• 28-5 Relationships Among Programs, Jobs, and Schedules
• 28-6 Scheduler Components
• 28-7 Oracle RAC Architecture and the Scheduler
• 28-8 Service Affinity and the Scheduler
• 29-1 Chain with Step 3 Paused
• 29-2 Sample Resource Plan
• 31-1 Homogeneous Distributed Database
• 31-2 An Oracle Database Distributed Database System
• 31-3 Database Link
• 31-4 Hierarchical Arrangement of Networked Databases
• 31-5 Global User Security
• 31-6 NLS Parameter Settings in a Client/Server Environment
• 31-7 NLS Parameter Settings in a Homogeneous Environment
• 31-8 NLS Parameter Settings in a Heterogeneous Environment
• 32-1 A Shared Database Link to Dedicated Server Processes
• 32-2 Shared Database Link to Shared Server
• 32-3 Views and Location Transparency
• 34-1 Distributed System
• 34-2 Example of a Session Tree
• 34-3 Commit Point Site
• 34-4 Commit Point Strengths and Determination of the Commit Point Site
• 34-5 Failure During Prepare Phase
• 34-6 Failure During Commit Phase
• 34-7 Defining the Session Tree
• 34-8 Determining the Commit Point Site
• 34-9 Sending and Acknowledging the Prepare Message
• 34-10 Instructing Nodes to Commit
• 35-1 Example of an In-Doubt Distributed Transaction