Database replay is Oracle 11g new feature and it is part of Oracle Real application testing. Another important feature of the Real Application testing is SQL Performance Analyzer (SPA) . The main difference between SPA and database replay is that we can customize the SQL set within the SPA and tune the SQL base on the SQL statement. Database replay is base on the entire system and consider the concurrence.
Create the test environment
CREATE OR REPLACE DIRECTORY db_replay_dir AS '/u01/app/oracle/db_replay';
CREATE USER db_replay1 IDENTIFIED BY db_replay1 QUOTA UNLIMITED ON users;
GRANT CONNECT, CREATE TABLE TO db_replay1;