1.主库建立负载过滤器BEGINDBMS_WORKLOAD_CAPTURE.ADD_FILTER (fname => 'filter_test',fattribute => 'USER',fvalue => 'SYSTEM');END;/2.主库建立负载文件存储目录create directory test_dir as '/u01/app/testfile';3.主库开始捕获负载BEGINDBMS_WORKLOAD_CAPTURE.START_CAPTURE (name => 'peak_120s',dir => 'TEST_DIR',duration => 120);END;/上面是 120 秒durationOptional 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.测试库预处理负载BEGINDBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => 'TEST_DIR');END;/8.测试库wrc校准wrc mode=calibrate replaydir=/u01/app/testfile9.测试库初始化重演BEGINDBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY (replay_name => 'peak_120s',replay_dir => 'TEST_DIR');END;/10.测试库设置负载重演的选项BEGINDBMS_WORKLOAD_REPLAY.PREPARE_REPLAY (synchronization => TRUE);END;/11.测试库wrc重演wrc system/oracle mode=replay replaydir=/u01/app/testfile另开一个session执行BEGINDBMS_WORKLOAD_REPLAY.START_REPLAY ();END;/12.结束重演,分析测试库 awr,删除重演信息DBMS_WORKLOAD_CAPTURE.DELETE_CAPTURE_INFOcapture_id IN NUMBER);
oracle workload capture,oracle重演
最新推荐文章于 2023-03-28 20:52:42 发布