Changes in This Release for Oracle Database Testing Guide

This preface lists changes in Oracle Database Testing Guide.

The following are changes in Oracle Database Testing Guide for Oracle Database 12c Release 2 (12.2.0.1).

This section describes the new SQL Performance Analyzer and DB Replay features in Oracle Database 12c Release 2 (12.2.0.1).

You can enable or disable the execution of triggers in a SQL Performance Analyzer analysis task.

See Configuring Trigger Execution in an Analysis Task.
You can configure the date to be returned by calls in a SQL Performance Analyzer analysis task.

See Configuring a Date to be Returned by Calls in an Analysis Task.
You can configure the number of rows to fetch in a SQL Performance Analyzer analysis task.

See Configuring the Number of Rows to Fetch for an Analysis Task
You can specify how user PL/SQL calls are handled during workload capture and workload replay with DB Replay.
See the following sections for more information:
The plsql_mode parameter can also be used with the INITIALIZE_CONSOLIDATED_REPLAY procedure, which is described in Initializing Consolidated Database Replay Using APIs.

This topic describes additional changes in Oracle Database Testing Guide for Oracle Database 12c Release 2 (12.2.0.1).

The following change was also made in Oracle Database Testing Guide for Oracle Database 12c Release 2 (12.2.0.1).:

The Test Data Management features that were documented in Part III of this manual in Oracle Database 12c Release 1 have been removed. These features are now documented in a separate manual: Oracle Data Masking and Subsetting Guide.

The following are changes in Oracle Database Testing Guide for Oracle Database 12c Release 1 (12.1).

The following features are new in this release:

SQL Performance Analyzer Quick Check (SPA Quick Check)

On some Oracle Enterprise Manager Cloud Control database management pages, SPA Quick Check can validate the impact of a system change to the database workload before you make the change.

See Using SPA Quick Check.
SQL Performance Analyzer support for the multitenant architecture

You can use a SQL tuning set that was transported from a non-CDB to a multitenant container database (CDB) as the input source to SQL Performance Analyzer by remapping its CDB identifiers.

See Remapping Multitenant Container Database Identifiers in an Analysis Task Using APIs.
Workload Intelligence

Workload Intelligence comprises a suite of Java programs that enable you to analyze the data stored in a captured workload.

See Using Workload Intelligence.
Consolidated Database Replay

Consolidated Database Replay enables you to consolidate multiple workloads captured from one or multiple systems and replay them concurrently on a single test system, such as a single Oracle Exadata Machine.

See Using Consolidated Database Replay.
Workload Scale-up

Database Replay enables you to perform scale-up testing and stress testing in various use cases and scenarios.

See Using Workload Scale-Up.

The following are additional changes in the release:

New book

Oracle Database Real Application Testing User's Guide is now part of Oracle Database Testing Guide.
New part

Part III “Test Data Management” was added to Oracle Database Testing Guide to describe the test data management features of Oracle Database.