1.主库建立负载过滤器
BEGIN
    DBMS_WORKLOAD_CAPTURE.ADD_FILTER (
    fname => 'filter_test',
    fattribute => 'USER',
    fvalue => 'SYSTEM');
    END;
    /
2.主库建立负载文件存储目录
create directory test_dir as '/u01/app/testfile';


3.主库开始捕获负载
BEGIN
    DBMS_WORKLOAD_CAPTURE.START_CAPTURE (name => 'peak_120s',
    dir => 'TEST_DIR',
    duration => 120);
    END;
    /
上面是 120 秒


duration


Optional input to specify the duration (in seconds) for which the workload needs to be captured. DEFAULT is NULL which means that workload capture will continue until the user executes DBMS_WORKLOAD_CAPTURE.FINISH_CAPTURE


如果不按时间,可以default 为0
注意 TEST_DIR 必须是大写


4.主库开始负载过程


5.主库等待负载过后,手工stop捕获


 exec dbms_workload_capture.FINISH_CAPTURE();


6.测试库建立负载文件存储目录
create directory test_dir as '/u01/app/testfile';


7.测试库预处理负载
BEGIN
    DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => 'TEST_DIR');
    END;
    /


8.测试库wrc校准
wrc mode=calibrate replaydir=/u01/app/testfile


9.测试库初始化重演


BEGIN
    DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY (replay_name => 'peak_120s',
    replay_dir => 'TEST_DIR');
    END;
    /


10.测试库设置负载重演的选项
 BEGIN
    DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY (synchronization => TRUE);
    END;
    /


11.测试库wrc重演


wrc system/oracle mode=replay replaydir=/u01/app/testfile


另开一个session执行
 BEGIN
    DBMS_WORKLOAD_REPLAY.START_REPLAY ();
    END;
    /


12.结束重演,分析测试库 awr,删除重演信息


DBMS_WORKLOAD_CAPTURE.DELETE_CAPTURE_INFO
   capture_id     IN   NUMBER);