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.
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.
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.
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.
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.
Workload Scale-up
Database Replay enables you to perform scale-up testing and stress testing in various use cases and scenarios.
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.