This section describes the new SQL Performance Analyzer and DB Replay features in Oracle Database release 19c, version 19.1.

• You can enable a workload capture and start a workload replay for the current pluggable database (PDB).

  See Also:

  Workload Capture and Replay in a PDB

• You can diagnose a slow workload replay by using the workload replay report.

  See Also:

  Reviewing Workload Replay Reports

• You can query the DBA_RAT_CAPTURE_SCHEMA_INFO view to obtain login_schema and current_schema that were in effect when SQL statements were recorded in a workload capture.

  See Also:

  Starting a Workload Replay

This section describes the new SQL Performance Analyzer and DB Replay features in Oracle Database release 18c, version 18.1.

• You can enable encryption for a workload capture using the new ENCRYPTION parameter.

  See Also:

  • Starting a Workload Capture

  • Starting Replay Clients

• You can encrypt and decrypt an existing workload capture.

  See Also:

  Encrypting and Decrypting an Existing Workload Capture Using APIs

• You can enable concurrent SQL execution with SQL Performance Analyzer using the new TEST_EXECUTE_DOP parameter.

  See Also:

  Configuring the Degree of Parallelism for an Analysis Task

• You can validate SQL result sets using the new COMPARE_RESULTSET parameter.

  See Also:

  Validating SQL Result Sets Using SQL Performance Analyzer

• You can perform Database Replay operations in a Database Vault environment if you have the necessary Database Vault authorizations.

  See Also:

  Oracle Database Vault Administrator’s Guide for information about using Database Replay in a Database Vault environment

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:

  • Starting a Workload Capture

  • Preprocessing a Database Workload Using APIs

  • Initializing Replay Data

  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.