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
- Creating an Analysis Task Using Enterprise Manager
- Creating an Analysis Task Using APIs
-
Configuring an Analysis Task Using APIs
- Configuring the Execution Plan Comparison Method of an Analysis Task Using APIs
- Configuring an Analysis Task for Exadata Simulation Using APIs
- Remapping Multitenant Container Database Identifiers in an Analysis Task Using APIs
- Configuring Trigger Execution in an Analysis Task
- Configuring a Date to be Returned by Calls in an Analysis Task
- Configuring the Number of Rows to Fetch for an Analysis Task
- Configuring the Degree of Parallelism for an Analysis Task
- 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
- Comparing SQL Trials Using Oracle Enterprise Manager
-
Comparing SQL Trials Using APIs
- Analyzing SQL Performance Using APIs
- Reviewing the SQL Performance Analyzer Report in Command-Line
- Comparing SQL Tuning Sets Using APIs
- Tuning Regressed SQL Statements Using APIs
- Tuning Regressed SQL Statements From a Remote SQL Trial Using APIs
- Creating SQL Plan Baselines Using APIs
- Using SQL Performance Analyzer Views
-
7
Using SPA Quick Check
- About Configuring SPA Quick Check
- Specifying Default Values for SPA Quick Check
- Validating the Impact of an Initialization Parameter Change
- Validating the Impact of Pending Optimizer Statistics
- Validating the Impact of Implementing Key SQL Profiles
- Validating Statistics Findings from Automatic SQL Tuning Advisor
-
8
Testing a Database Upgrade
- Upgrading from Oracle9i Database and Oracle Database 10g Release 1
- Upgrading from Oracle Database 10g Release 2 and Newer Releases
- Tuning Regressed SQL Statements After Testing a Database Upgrade
-
Part II Database Replay
- 9 Introduction to Database Replay
-
10
Capturing a Database Workload
- Prerequisites for Capturing a Database Workload
- Setting Up the Capture Directory
- Workload Capture Options
- Workload Capture Restrictions
- Enabling and Disabling the Workload Capture Feature
- Enterprise Manager Privileges and Roles
- Capturing a Database Workload Using Enterprise Manager
- Capturing Workloads from Multiple Databases Concurrently
- Monitoring a Workload Capture Using Enterprise Manager
- Importing a Workload External to Enterprise Manager
- Creating Subsets from an Existing Workload
- Copying or Moving a Workload to a New Location
- Capturing a Database Workload Using APIs
- Encrypting and Decrypting an Existing Workload Capture Using APIs
- Monitoring Workload Capture Using Views
- 11 Preprocessing a Database Workload
-
12
Replaying a Database Workload
- Steps for Replaying a Database Workload
- Replaying a Database Workload Using Enterprise Manager
- Setting Up the Replay Schedule and Parameters Using Enterprise Manager
- Monitoring Workload Replay Using Enterprise Manager
- Importing a Replay External to Enterprise Manager
-
Replaying a Database Workload Using APIs
- Initializing Replay Data
- Remapping Connections
- Remapping Users
- Setting Workload Replay Options
- Defining Workload Replay Filters and Replay Filter Sets
- Setting the Replay Timeout Action
- Starting a Workload Replay
- Pausing a Workload Replay
- Resuming a Workload Replay
- Cancelling a Workload Replay
- Retrieving Information About Workload Replays
- Loading Divergence Data for Workload Replay
- Deleting Information About Workload Replays
- Exporting AWR Data for Workload Replay
- Importing AWR Data for Workload Replay
- Monitoring Workload Replay Using APIs
- 13 Analyzing Captured and Replayed Workloads
- 14 Using Workload Intelligence
-
15
Using Consolidated Database Replay
- Use Cases for Consolidated Database Replay
-
Steps for Using Consolidated Database Replay
- Capturing Database Workloads for Consolidated Database Replay
- Setting Up the Test System for Consolidated Database Replay
- Preprocessing Database Workloads for Consolidated Database Replay
- Replaying Database Workloads for Consolidated Database Replay
- Reporting and Analysis for Consolidated Database Replay
- Using Consolidated Database Replay with Enterprise Manager
- Using Consolidated Database Replay with APIs
- About Query-Only Database Replay
- Example: Replaying a Consolidated Workload with APIs
- 16 Using Workload Scale-Up
-
Part III Workload Analysis
- 17 Using Workload Analysis
- Index