List of Tables

• 4-1 Necessary Initialization Parameters Without Performance Impact
• 4-2 Important Initialization Parameters With Performance Impact
• 4-3 Wait Time and Request Columns in V$QUEUE
• 5-1 UNIX Tools for Operating Statistics
• 5-2 Activity Over Time
• 7-1 Statistics for Calculating the Hit Ratio
• 7-2 V$ROWCACHE Columns
• 7-3 V$SESSTAT Statistics Reflecting Memory
• 7-4 Client Result Cache Initialization Parameters
• 7-5 Values for the RESULT_CACHE_MODE Initialization Parameter
• 7-6 Views and Tables Related to the Server and Client Result Caches
• 8-1 Oracle Database and Operating System Operational Parameters
• 8-2 Minimum Stripe Depth
• 8-3 Block Size Advantages and Disadvantages
• 8-4 Orion I/O Workload Support
• 8-5 Required Orion Parameter
• 8-6 Optional Orion Parameters
• 8-7 Orion Generated Output Files
• 10-1 Wait Events and Potential Causes
• 10-2 Idle Wait Events
• 10-3 Latch Wait Event
• 10-4 V$INSTANCE_RECOVERY Columns
• 11-1 Optimizer Operations
• 11-2 Table Caching Criteria
• 11-3 Initialization Parameters That Control Optimizer Behavior
• 11-4 OPTIMIZER_MODE Initialization Parameter Values
• 11-5 Hints for Changing the Query Optimizer Goal
• 12-1 PLAN_TABLE Columns
• 12-2 Values of DISTRIBUTION Column of the PLAN_TABLE
• 12-3 OPERATION and OPTIONS Values Produced by EXPLAIN PLAN
• 13-1 Statistics Gathering Procedures in the DBMS_STATS Package
• 13-2 Parameters for the create_extended_statistics Function
• 13-3 Parameters for the show_extended_stats_name Function
• 13-4 Parameters for the drop_extended_stats Function
• 13-5 Setting Preferences for Gathering Statistics
• 13-6 Functions That Compare Statistics in the DBMS_STATS Package
• 13-7 Optimizer System Statistics in the DBMS_STAT Package
• 13-8 Default Table Values When Statistics Are Missing
• 13-9 Default Index Values When Statistics Are Missing
• 13-10 Dynamic Sampling Levels
• 15-1 Outline Categories
• 15-2 DBMS_SPM Functions Relating to Stored Outline Migration
• 15-3 Parameters Relating to Stored Outline Migration
• 15-4 Views Relating to Stored Outline Migration
• 15-5 Creation of Outlines and Baselines
• 15-6 Use of Stored Outlines and SQL Plan Baselines
• 16-1 SQL Test Case Builder Procedures in DBMS_SQLDIAG
• 17-1 SET_AUTO_TUNING_TASK_PARAMETER Automatic SQL Tuning Parameters
• 17-2 SET_TUNING_TASK_PARAMETER Procedure Parameters
• 17-3 DBMS_SQLTUNE APIs for SQL Profiles
• 18-1 Types of Advisor Task Parameters And Their Uses
• 18-2 SQL Access Advisor Action Attributes
• 18-3 SQL Access Advisor Constants
• 21-1 Initialization Parameters to Check Before Enabling SQL Trace
• 21-2 TKPROF Arguments
• 21-3 CALL Column Values
• 21-4 SQL Trace Statistics for Parses, Executes, and Fetches.
• 21-5 SQL Trace Statistics for the ROWS Column
• 21-6 TKPROF_TABLE Columns for Identifying a Row of Statistics