Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database Testing Guide
- 1 Introduction to Oracle Database Testing
-
Part I SQL Performance Analyzer
- 2 Introduction to SQL Performance Analyzer
-
3
Creating an Analysis Task
- 3.1 Creating an Analysis Task Using Enterprise Manager
- 3.2 Creating an Analysis Task Using APIs
-
3.3
Configuring an Analysis Task Using APIs
- 3.3.1 Configuring the Execution Plan Comparison Method of an Analysis Task Using APIs
- 3.3.2 Configuring an Analysis Task for Exadata Simulation Using APIs
- 3.3.3 Remapping Multitenant Container Database Identifiers in an Analysis Task Using APIs
- 3.3.4 Configuring Trigger Execution in an Analysis Task
- 3.3.5 Configuring a Date to be Returned by Calls in an Analysis Task
- 3.3.6 Configuring the Number of Rows to Fetch for an Analysis Task
- 3.3.7 Configuring the Degree of Parallelism for an Analysis Task
- 3.3.8 Validating SQL Result Sets Using SQL Performance Analyzer
- 4 Creating a Pre-Change SQL Trial
- 5 Creating a Post-Change SQL Trial
-
6
Comparing SQL Trials
- 6.1 Comparing SQL Trials Using Oracle Enterprise Manager
-
6.2
Comparing SQL Trials Using APIs
- 6.2.1 Analyzing SQL Performance Using APIs
- 6.2.2 Reviewing the SQL Performance Analyzer Report in Command-Line
- 6.2.3 Comparing SQL Tuning Sets Using APIs
- 6.2.4 Tuning Regressed SQL Statements Using APIs
- 6.2.5 Tuning Regressed SQL Statements From a Remote SQL Trial Using APIs
- 6.2.6 Creating SQL Plan Baselines Using APIs
- 6.2.7 Using SQL Performance Analyzer Views
-
7
Using SPA Quick Check
- 7.1 About Configuring SPA Quick Check
- 7.2 Specifying Default Values for SPA Quick Check
- 7.3 Validating the Impact of an Initialization Parameter Change
- 7.4 Validating the Impact of Pending Optimizer Statistics
- 7.5 Validating the Impact of Implementing Key SQL Profiles
- 7.6 Validating Statistics Findings from Automatic SQL Tuning Advisor
-
8
Testing a Database Upgrade
- 8.1 Upgrading from Oracle9i Database and Oracle Database 10g Release 1
- 8.2 Upgrading from Oracle Database 10g Release 2 and Newer Releases
- 8.3 Tuning Regressed SQL Statements After Testing a Database Upgrade
-
Part II Database Replay
- 9 Introduction to Database Replay
-
10
Capturing a Database Workload
- 10.1 Prerequisites for Capturing a Database Workload
- 10.2 Setting Up the Capture Directory
- 10.3 Workload Capture Options
- 10.4 Workload Capture Restrictions
- 10.5 Enabling and Disabling the Workload Capture Feature
- 10.6 Enterprise Manager Privileges and Roles
- 10.7 Capturing a Database Workload Using Enterprise Manager
- 10.8 Capturing Workloads from Multiple Databases Concurrently
- 10.9 Monitoring a Workload Capture Using Enterprise Manager
- 10.10 Importing a Workload External to Enterprise Manager
- 10.11 Creating Subsets from an Existing Workload
- 10.12 Copying or Moving a Workload to a New Location
- 10.13 Capturing a Database Workload Using APIs
- 10.14 Encrypting and Decrypting an Existing Workload Capture Using APIs
- 10.15 Monitoring Workload Capture Using Views
- 11 Preprocessing a Database Workload
-
12
Replaying a Database Workload
- 12.1 Steps for Replaying a Database Workload
- 12.2 Replaying a Database Workload Using Enterprise Manager
- 12.3 Setting Up the Replay Schedule and Parameters Using Enterprise Manager
- 12.4 Monitoring Workload Replay Using Enterprise Manager
- 12.5 Importing a Replay External to Enterprise Manager
-
12.6
Replaying a Database Workload Using APIs
- 12.6.1 Initializing Replay Data
- 12.6.2 Remapping Connections
- 12.6.3 Remapping Users
- 12.6.4 Setting Workload Replay Options
- 12.6.5 Defining Workload Replay Filters and Replay Filter Sets
- 12.6.6 Setting the Replay Timeout Action
- 12.6.7 Starting a Workload Replay
- 12.6.8 Pausing a Workload Replay
- 12.6.9 Resuming a Workload Replay
- 12.6.10 Cancelling a Workload Replay
- 12.6.11 Retrieving Information About Workload Replays
- 12.6.12 Loading Divergence Data for Workload Replay
- 12.6.13 Deleting Information About Workload Replays
- 12.6.14 Exporting AWR Data for Workload Replay
- 12.6.15 Importing AWR Data for Workload Replay
- 12.7 Monitoring Workload Replay Using APIs
-
13
Analyzing Captured and Replayed Workloads
- 13.1 Using Workload Capture Reports
- 13.2 Using Workload Replay Reports
-
13.3
Using Replay Compare Period Reports
- 13.3.1 Generating Replay Compare Period Reports Using APIs
- 13.3.2 Reviewing Replay Compare Period Reports
- 13.4 Using SQL Performance Analyzer Reports
- 14 Using Workload Intelligence
-
15
Using Consolidated Database Replay
- 15.1 Use Cases for Consolidated Database Replay
-
15.2
Steps for Using Consolidated Database Replay
- 15.2.1 Capturing Database Workloads for Consolidated Database Replay
- 15.2.2 Setting Up the Test System for Consolidated Database Replay
- 15.2.3 Preprocessing Database Workloads for Consolidated Database Replay
- 15.2.4 Replaying Database Workloads for Consolidated Database Replay
- 15.2.5 Reporting and Analysis for Consolidated Database Replay
- 15.3 Using Consolidated Database Replay with Enterprise Manager
- 15.4 Using Consolidated Database Replay with APIs
- 15.5 About Query-Only Database Replay
- 15.6 Example: Replaying a Consolidated Workload with APIs
- 16 Using Workload Scale-Up
- Index