Oracle 11g introduced database replay as part of Real Application Testing.

Database replay is a feature that enables us to capture a database load from Oracle 9i (9.2.0.8), 10g (10.2.0.2 and up) and 11g, and replay the same load on an 11g database.

This provides us with the ability to check actual database load on a test environment before we upgrade the database or change anything in the application or infrastructure.

In this video clip we will see the first part of database replay – the capture.

We will use database replay API using SQL*Plus to capture a load in a 10.2.0.4 database.

The next step – Database Replay Part 2 – Process Video tutorial