List of Tables

• 1-1 Required Password File Name and Location on UNIX, Linux, and Windows
• 2-1 Database Planning Tasks
• 2-2 Recommended Minimum Initialization Parameters
• 2-3 Database Components and the SYSAUX Tablespace
• 2-4 PFILE and SPFILE Default Names and Locations on UNIX, LInux, and Windows
• 4-1 Oracle Components Automatically Restarted by Oracle Restart
• 4-2 Create Operations and the Oracle Restart Configuration
• 4-3 Delete/Drop/Remove Operations and the Oracle Restart Configuration
• 4-4 Event Record Parameters and Descriptions
• 4-5 FAN Parameters and Matching Database Signatures
• 4-6 Determining the Oracle Home from which to Start SRVCTL
• 4-7 Summary of SRVCTL Commands
• 4-8 Component Keywords and Abbreviations
• 4-9 srvctl add Summary
• 4-10 srvctl add asm Options
• 4-11 srvctl add database Options
• 4-12 srvctl add eons Options
• 4-13 srvctl add listener Options
• 4-14 srvctl add ons Options
• 4-15 srvctl add service Options
• 4-16 srvctl config Summary
• 4-17 srvctl config asm Options
• 4-18 srvctl config database Options
• 4-19 srvctl config listener Options
• 4-20 srvctl config service Options
• 4-21 srvctl disable Summary
• 4-22 srvctl disable database Options
• 4-23 srvctl disable diskgroup Options
• 4-24 srvctl disable eons Options
• 4-25 srvctl disable listener Options
• 4-26 srvctl disable ons Options
• 4-27 srvctl disable service Options
• 4-28 srvctl enable Summary
• 4-29 srvctl enable database Options
• 4-30 srvctl enable diskgroup Options
• 4-31 srvctl enable eons Options
• 4-32 srvctl enable listener Options
• 4-33 srvctl enable ons Options
• 4-34 srvctl enable service Options
• 4-35 srvctl getenv Summary
• 4-36 srvctl getenv asm Options
• 4-37 srvctl getenv database Options
• 4-38 srvctl getenv listener Options
• 4-39 srvctl modify Summary
• 4-40 srvctl modify asm Options
• 4-41 srvctl modify database Options
• 4-42 srvctl modify eons Options
• 4-43 srvctl modify listener Options
• 4-44 srvctl modify ons Options
• 4-45 srvctl modify service Options
• 4-46 srvctl remove Summary
• 4-47 srvctl remove asm Options
• 4-48 srvctl remove database Options
• 4-49 srvctl remove diskgroup Options
• 4-50 srvctl remove eons Options
• 4-51 srvctl remove listener Options
• 4-52 srvctl remove ons Options
• 4-53 srvctl remove service Options
• 4-54 srvctl setenv and unsetenv Summary
• 4-55 srvctl setenv database Options
• 4-56 srvctl setenv database Options
• 4-57 srvctl setenv listener Options
• 4-58 srvctl start Summary
• 4-59 srvctl start asm Option
• 4-60 srvctl start database Options
• 4-61 srvctl start diskgroup Options
• 4-62 srvctl start eons Options
• 4-63 srvctl start home Options
• 4-64 srvctl start listener Options
• 4-65 srvctl start ons Options
• 4-66 srvctl start service Options
• 4-67 srvctl status Summary
• 4-68 srvctl status asm Options
• 4-69 srvctl status database Options
• 4-70 srvctl status diskgroup Options
• 4-71 srvctl status home Options
• 4-72 srvctl status listener Options
• 4-73 srvctl status service Options
• 4-74 srvctl stop Summary
• 4-75 srvctl stop asm Option
• 4-76 srvctl stop database Options
• 4-77 srvctl stop diskgroup Options
• 4-78 srvctl stop eons Options
• 4-79 srvctl stop home Options
• 4-80 srvctl stop listener Options
• 4-81 srvctl stop ons Options
• 4-82 srvctl stop service Options
• 4-83 srvctl unsetenv Command Summary
• 4-84 srvctl unsetenv asm Options
• 4-85 srvctl unsetenv database Options
• 4-86 srvctl unsetenv listener Options
• 4-87 Summary of CRSCTL Commands
• 4-88 crsctl stop has Options
• 5-1 Differences Between Dedicated Servers, Shared Servers, and Database Resident Connection Pooling
• 5-2 Configuration Parameters for Database Resident Connection Pooling
• 5-3 Data Dictionary Views for Database Resident Connection Pooling
• 5-4 Oracle Database Background Processes
• 6-1 Automatically Sized SGA Components and Corresponding Parameters
• 6-2 Manually Sized SGA Components that Use SGA_TARGET Space
• 9-1 ADR Home Path Components for Oracle Database
• 9-2 ADR Home Subdirectories
• 9-3 Data in the V$DIAG_INFO View
• 9-4 Oracle Advisors that Help Repair Critical Errors
• 9-5 Parameters for Data Block Integrity Check
• 9-6 Parameters for Redo Integrity Check
• 9-7 Parameters for Undo Segment Integrity Check
• 9-8 Parameters for Transaction Integrity Check
• 9-9 Parameters for Dictionary Integrity Check
• 12-1 LOG_ARCHIVE_MIN_SUCCEED_DEST Values for Scenario 1
• 12-2 LOG_ARCHIVE_MIN_SUCCEED_DEST Values for Scenario 2
• 13-1 Minimum Compatibility Requirements
• 17-1 DBA Tasks for Edition-Based Redefinition
• 18-1 DBMS_ADVISOR package procedures relevant to the Segment Advisor
• 18-2 Input for DBMS_ADVISOR.CREATE_OBJECT
• 18-3 Input for DBMS_ADVISOR.SET_TASK_PARAMETER
• 18-4 Segment Advisor Result Types
• 18-5 Segment Advisor Outcomes: Summary
• 19-1 Table Compression Methods
• 19-2 Mandatory Error Description Columns
• 19-3 Error Logging Table Column Data Types
• 19-4 ALTER TABLE Clauses for External Tables
• 20-1 Costs and Benefits of Coalescing or Rebuilding Indexes
• 24-1 Comparison of Corruption Detection Methods
• 25-1 Predefined Maintenance Windows
• 25-2 Automated Maintenance Tasks Database Dictionary Views
• 26-1 A Simple Three-Level Resource Plan
• 26-2 A Three-Level Resource Plan with Maximum Utilization Limits
• 26-3 Predefined Resource Plans
• 26-4 Predefined Resource Consumer Groups
• 26-5 Predefined Consumer Group Mapping Rules
• 26-6 Resource Manager Data Dictionary Views
• 27-1 Default Credentials for Local External Jobs
• 28-1 Job Tasks and Their Procedures
• 28-2 Credential and Destination Tasks and Their Procedures
• 28-3 Program Tasks and Their Procedures
• 28-4 Schedule Tasks and Their Procedures
• 28-5 Event Tasks and Their Procedures for Events Raised by an Application
• 28-6 Chain Tasks and Their Procedures
• 28-7 Values for the State Attribute of a Chain Step
• 28-8 Job Class Tasks and Their Procedures
• 28-9 Window Tasks and Their Procedures
• 28-10 Window Group Tasks and Their Procedures
• 28-11 Job Logging Levels
• 28-12 Scheduler Data Dictionary View Contents for Multiple-Destination Jobs
• 28-13 Job State Event Types Raised by the Scheduler
• 29-1 Job States
• 29-2 Scheduler System Privileges
• 29-3 Scheduler Object Privileges
• 29-4 Scheduler Views
• 34-1 DBA_2PC_PENDING
• 34-2 DBA_2PC_NEIGHBORS