1、准备捕获负载
a> mkdir dbcapture
b> sql>create directory dbcapture as 'c:\oracle\dbcapture';
2、捕获负载
a> SQL> exec dbms_workload_capture.start_capture('NRML_ACTIVITY','DBCAPTURE');
b>SQL> exec dbms_workload_capture.finish_capture();
生成捕获报告:
详见P323
准备负载以回放:
1、c:\oracle> mkdir replay
2、copy c:\oracle\dbcapture\* c:\oracle\replay
3、SQL> create directory REPLAY as 'c:\oracle\replay';
4、SQL> exec dbms_workload_replay.process_capture('REPLAY');
5、SQL> exec dbms_workload_replay.initialize_replay('TEST_REPLAY','REPLAY');
6、SQL> exec dbms_workload_replay.prepare_replay(synchronization=>TRUE);
7、cd c:\oracle\replay> wrc mode=calibrate
执行回放:
1、c:\oracle\replay> wrc system/xxxx@orc112c replaydir=c:\oracle\replay>
2、SQL>execute DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
3、SQL> exec dbms_workload_replay.start_replay;
4、SQL> execute DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
提取负载回放报告:
P326