My Oracle Support Banner

How to Setup and Run a Database Testing Replay in an Oracle Multitenant Environment (Real Application Testing - RAT) (Doc ID 1937920.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

Demonstrate how to setup and run a Database Replay within Oracle Multitenant Environment against one or more pluggable databases.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Example of Consolidated Replay for multiple PDB(s):
 Step 1:  Create the Directories for the Consolidated Replay
 Step 2: Preprocess the workload for each replay
 Step 3: Setup the Replay Directory
 Step 4: Create Replay schedule and add the individual Workload Captures
 Step 5: Initialize Consolidated Replay
 Step 6: Remap connections to the respective PDB(s)
  Step 7: Prepare Consolidated Replay
 Step 8: Deploy and start the wrc clients
 Step 9: Start the Replay
 Step 10: Create the Replay report once the replay has finished
 Example of Replay for a single PDB
 Step 1: Create the Directories for the Replay
  Step 2: Preprocess the workload for the replay
  Step 3: Initialize the Replay
  Step 4: Remap the connections to the PDB
  Step 5: Prepare the Replay
  Step 6: Deploy and start the wrc clients
  Step 7: Start the Replay
 Step 8: Create the Replay report once the replay has finished
 Additional References:


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.