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 Incidents and Problems Section of the Database Home Page
• 9-5 Enterprise Manager Support Workbench Home Page
• 9-6 Select Package Page
• 9-7 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
• 19-1 Tables page
• 19-2 Advisor Central 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
• 36-1 CDB with PDBs
• 36-2 A Newly Created CDB
• 36-3 A CDB with PDBs
• 37-1 A Newly Created CDB
• 37-2 CDB with PDBs
• 38-1 Options for Creating a PDB
• 38-2 Create a PDB Using the Seed Files
• 38-3 Clone a Local PDB
• 38-4 Creating a PDB by Cloning a Remote PDB
• 38-5 Creating a PDB by Cloning a Non-CDB
• 38-6 Plug In an Unplugged PDB
• 38-7 Plug In a Non-CDB Using the DBMS_PDB.DESCRIBE Procedure
• 38-8 Unplug a PDB
• 39-1 Managing PDBs
• 44-1 Shares in a CDB Resource Plan
• 44-2 Shares and Utilization Limits in a CDB Resource Plan
• 44-3 Default Directive in a CDB Resource Plan
• 44-4 A CDB Resource Plan and a PDB Resource Plan