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
2-4 DBCA Silent Mode Options
2-5 DBCA Silent Mode Commands
2-6 createDatabase Parameters
2-7 configureDatabase Parameters
2-8 createTemplateFromDB Parameters
2-9 createCloneTemplate Parameters
2-10 generateScripts Parameters
2-11 deleteDatabase Parameters
2-12 createPluggableDatabase Parameters
2-13 unplugDatabase Parameters
2-14 deletePluggableDatabase Parameters
2-15 configurePluggableDatabase Parameters
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 downgrade database Options
4-27 srvctl enable Summary
4-28 srvctl enable database Options
4-29 srvctl enable diskgroup Options
4-30 srvctl enable listener Options
4-31 srvctl enable ons Options
4-32 srvctl enable service Options
4-33 srvctl getenv Summary
4-34 srvctl getenv asm Options
4-35 srvctl getenv database Options
4-36 srvctl getenv listener Options
4-37 srvctl modify Summary
4-38 srvctl modify asm Options
4-39 srvctl modify database Options
4-40 srvctl modify listener Options
4-41 srvctl modify ons Options
4-42 srvctl modify service Options
4-43 srvctl remove Summary
4-44 srvctl remove asm Options
4-45 srvctl remove database Options
4-46 srvctl remove diskgroup Options
4-47 srvctl remove listener Options
4-48 srvctl remove ons Options
4-49 srvctl remove service Options
4-50 srvctl setenv and unsetenv Summary
4-51 srvctl setenv database Options
4-52 srvctl setenv database Options
4-53 srvctl setenv listener Options
4-54 srvctl start Summary
4-55 srvctl start asm Option
4-56 srvctl start database Options
4-57 srvctl start diskgroup Options
4-58 srvctl start home Options
4-59 srvctl start listener Options
4-60 srvctl start ons Options
4-61 srvctl start service Options
4-62 srvctl status Summary
4-63 srvctl status asm Options
4-64 srvctl status database Options
4-65 srvctl status diskgroup Options
4-66 srvctl status home Options
4-67 srvctl status listener Options
4-68 srvctl status ons Options
4-69 srvctl status service Options
4-70 srvctl stop Summary
4-71 srvctl stop asm Option
4-72 srvctl stop database Options
4-73 srvctl stop diskgroup Options
4-74 srvctl stop home Options
4-75 srvctl stop listener Options
4-76 srvctl stop ons Options
4-77 srvctl stop service Options
4-78 srvctl unsetenv Command Summary
4-79 srvctl unsetenv asm Options
4-80 srvctl unsetenv database Options
4-81 srvctl unsetenv listener Options
4-82 srvctl upgrade database Parameters
4-83 srvctl upgrade database Parameters
4-84 Summary of CRSCTL Commands
4-85 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 Granule Size
6-2 Automatically Sized SGA Components and Corresponding Parameters
6-3 Manually Sized SGA Components that Use SGA_TARGET Space
6-4 Database Smart Flash Cache Initialization Parameters
6-5 IM Column Store Compression Methods
6-6 Priority Levels for Populating a Database Object in the IM Column Store
6-7 Initialization Parameters Related to the IM Column Store
8-1 The MAX_DUMP_FILE_SIZE Parameter and Trace File Segmentation
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
12-1 LOG_ARCHIVE_MIN_SUCCEED_DEST Values for Scenario 1
12-2 LOG_ARCHIVE_MIN_SUCCEED_DEST Values for Scenario 2
15-1 Scenarios for Transportable Tablespaces and Transportable Tables
15-2 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 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 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
37-1 Planning for a CDB
38-1 Techniques for Creating a PDB
38-2 Clauses for Creating a PDB From the Seed
38-3 Clauses for Cloning a PDB
38-4 Clauses for Plugging In an Unplugged PDB
39-1 Getting Started with PDBs
40-1 Administrative Tasks Common to CDBs and Non-CDBs
40-2 Manageability Features in a CDB
40-3 Statements That Modify Containers in a CDB
40-4 Temporary Tablespaces in a CDB
40-5 PDB Modes
40-6 ALTER PLUGGABLE DATABASE Clauses That Modify the Mode of a PDB
40-7 Modifying the Open Mode of PDBs with ALTER PLUGGABLE DATABASE
40-8 Modifying the Open Mode of a PDB with STARTUP PLUGGABLE DATABASE
40-9 DDL Statements and the CONTAINER Clause in a CDB
40-10 catcon.pl Parameters
42-1 Administrative Tasks Common to PDBs and Non-CDBs
43-1 CON_ID Column in Container Data Objects
43-2 Views for a CDB
43-3 Functions That Return the Container ID of a Container
44-1 Resource Allocation for Sample PDBs
44-2 Utilization Limits for PDBs
44-3 Initial Default Directive Attributes for PDBs
44-4 CDB Resource Plan Requirements for PDB Resource Plans
44-5 Attributes for PDB Directives in a CDB Resource Plan
44-6 Sample Directives for PDBs in a CDB Resource Plan

Page 3 of 61