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 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 listener Options
• 4-13 srvctl add ons Options
• 4-14 srvctl add service Options
• 4-15 srvctl config Summary
• 4-16 srvctl config asm Options
• 4-17 srvctl config database Options
• 4-18 srvctl config listener Options
• 4-19 srvctl config service Options
• 4-20 srvctl disable Summary
• 4-21 srvctl disable database Options
• 4-22 srvctl disable diskgroup Options
• 4-23 srvctl disable listener Options
• 4-24 srvctl disable ons Options
• 4-25 srvctl disable service Options
• 4-26 srvctl enable Summary
• 4-27 srvctl enable database Options
• 4-28 srvctl enable diskgroup Options
• 4-29 srvctl enable listener Options
• 4-30 srvctl enable ons Options
• 4-31 srvctl enable service Options
• 4-32 srvctl getenv Summary
• 4-33 srvctl getenv asm Options
• 4-34 srvctl getenv database Options
• 4-35 srvctl getenv listener Options
• 4-36 srvctl modify Summary
• 4-37 srvctl modify asm Options
• 4-38 srvctl modify database Options
• 4-39 srvctl modify listener Options
• 4-40 srvctl modify ons Options
• 4-41 srvctl modify service Options
• 4-42 srvctl remove Summary
• 4-43 srvctl remove asm Options
• 4-44 srvctl remove database Options
• 4-45 srvctl remove diskgroup Options
• 4-46 srvctl remove listener Options
• 4-47 srvctl remove ons Options
• 4-48 srvctl remove service Options
• 4-49 srvctl setenv and unsetenv Summary
• 4-50 srvctl setenv database Options
• 4-51 srvctl setenv database Options
• 4-52 srvctl setenv listener Options
• 4-53 srvctl start Summary
• 4-54 srvctl start asm Option
• 4-55 srvctl start database Options
• 4-56 srvctl start diskgroup Options
• 4-57 srvctl start home Options
• 4-58 srvctl start listener Options
• 4-59 srvctl start ons Options
• 4-60 srvctl start service Options
• 4-61 srvctl status Summary
• 4-62 srvctl status asm Options
• 4-63 srvctl status database Options
• 4-64 srvctl status diskgroup Options
• 4-65 srvctl status home Options
• 4-66 srvctl status listener Options
• 4-67 srvctl status service Options
• 4-68 srvctl stop Summary
• 4-69 srvctl stop asm Option
• 4-70 srvctl stop database Options
• 4-71 srvctl stop diskgroup Options
• 4-72 srvctl stop home Options
• 4-73 srvctl stop listener Options
• 4-74 srvctl stop ons Options
• 4-75 srvctl stop service Options
• 4-76 srvctl unsetenv Command Summary
• 4-77 srvctl unsetenv asm Options
• 4-78 srvctl unsetenv database Options
• 4-79 srvctl unsetenv listener Options
• 4-80 Summary of CRSCTL Commands
• 4-81 crsctl stop has Options
• 5-1 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
• 6-3 Flash Cache Initialization Parameters
• 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 Data in the V$DIAG_CRITICAL_ERROR View
• 9-5 Oracle Advisors that Help Repair Critical Errors
• 9-6 Parameters for Data Block Integrity Check
• 9-7 Parameters for Redo Integrity Check
• 9-8 Parameters for Undo Segment Integrity Check
• 9-9 Parameters for Transaction Integrity Check
• 9-10 Parameters for Dictionary Integrity Check
• 10-1 EMCA Command-Line Operations
• 10-2 EMCA Command-Line Flags
• 10-3 EMCA Command-Line Parameters
• 13-1 LOG_ARCHIVE_MIN_SUCCEED_DEST Values for Scenario 1
• 13-2 LOG_ARCHIVE_MIN_SUCCEED_DEST Values for Scenario 2
• 14-1 Minimum Compatibility Requirements
• 18-1 DBA Tasks for Edition-Based Redefinition
• 19-1 DBMS_ADVISOR package procedures relevant to the Segment Advisor
• 19-2 Input for DBMS_ADVISOR.CREATE_OBJECT
• 19-3 Input for DBMS_ADVISOR.SET_TASK_PARAMETER
• 19-4 Segment Advisor Result Types
• 19-5 Segment Advisor Outcomes: Summary
• 20-1 Table Compression Methods
• 20-2 Table Compression Characteristics
• 20-3 Mandatory Error Description Columns
• 20-4 Error Logging Table Column Data Types
• 20-5 ALTER TABLE Clauses for External Tables
• 21-1 Costs and Benefits of Coalescing or Rebuilding Indexes
• 25-1 Comparison of Corruption Detection Methods
• 26-1 Predefined Maintenance Windows
• 26-2 Automated Maintenance Tasks Database Dictionary Views
• 27-1 A Simple Three-Level Resource Plan
• 27-2 A Three-Level Resource Plan with Maximum Utilization Limits
• 27-3 Resource Plan with Parallel Statement Directives
• 27-4 Predefined Resource Plans
• 27-5 Predefined Resource Consumer Groups
• 27-6 Predefined Consumer Group Mapping Rules
• 27-7 Resource Manager Data Dictionary Views
• 28-1 Default Credentials for Local External Jobs
• 29-1 Job Tasks and Their Procedures
• 29-2 Credential and Destination Tasks and Their Procedures
• 29-3 Program Tasks and Their Procedures
• 29-4 Schedule Tasks and Their Procedures
• 29-5 Event Tasks and Their Procedures for Events Raised by an Application
• 29-6 Chain Tasks and Their Procedures
• 29-7 Values for the State Attribute of a Chain Step
• 29-8 Job Class Tasks and Their Procedures
• 29-9 Window Tasks and Their Procedures
• 29-10 Window Group Tasks and Their Procedures
• 29-11 Job Logging Levels
• 29-12 Scheduler Data Dictionary View Contents for Multiple-Destination Jobs
• 29-13 Job State Event Types Raised by the Scheduler
• 30-1 schagent options
• 30-2 Job States
• 30-3 Scheduler System Privileges
• 30-4 Scheduler Object Privileges
• 30-5 Scheduler Views
• 35-1 DBA_2PC_PENDING
• 35-2 DBA_2PC_NEIGHBORS