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.
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.
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