Real Application Testing – Database Replay (2)

Hi Friends,

We learned how to capture the workload on the Oracle Enterprise Manager using RAT-Database Replay feature. In this article, we will learn the process of preprocessing the workload on the Oracle Enterprise Manager. Preprocessing prepares a captured workload for replay. This operation must be done once after each capture.This step is performed on the test system to replay. Now let’s implement a step by step.

Prerequisites

1- Allocate physical disk space on the test system. Create a directory on OS.

# mkdir /data1/dbreplay

2- Copy the captured files into /data1/dbreplay  directory.

3- Create Oracle directory object.

SQL> CREATE DIRECTORY capturedir AS ‘ /data1/dbreplay ‘;

Now you can proceed to preprocess the workload on OEM.

1- Login to OEM

2- Click “Database” link.

3- Click “Software and Support” page. Click “Database Replay” link under “Real Application Testing”

4-Click “Go to task” button across the “Preprocess Workload”

5-Choose directory object “CAPTUREDIR” and click “Preprocess Workload” button.

6-Click Next.

7- Write OS username and password and click next. 
8-Click Submit button.

9- A job will proceed to preprocess captured files for replay. You can click “View Job” link to monitor job status

In the next article I will write the Replay and Analyse phase.

To meet in the next article …

Talip Hakan Öztürk

 

How to Capture the Workload using the Oracle Enterprise Manager? Database Replay-1

How to Preprocess the Workload for Replay using the Oracle Enterprise Manager? Database Replay-2

How to Replay the Workload using the Oracle Enterprise Manager? Database Replay-3

Advertisement