Oracle RAT- Real Application Testing
来源:互联网 发布:linux 线程cpu利用率 编辑:程序博客网 时间:2024/06/09 20:12
RAT 是Oracle 11g的一个新特性.它的目的是评估数据的性能。当我们对数据库进行升级或改动一些配置,换数据库服务器时可以对改动之前和改动之后的性能进行对比.要使两者的性能具有可比性,并且切合实际。就需要先在生产环境中capture某一个时间段的所有操作。然后把它们在测试环境中进行replay.
一.Capture步骤
二.Replay 准备工作
- 把目标server上的capture files拷贝到测试的server上.假设在测试的server上同样建一个目标d:\capture
- 创建一个Oracle 目录:create directory dir1 as ‘d:\capture’
Process workload:dbms_workload_replay.process_capture
(
capture_dir => ‘DIR1′)
);
- Initialize the replay
dbms_workload_replay.initialize_replay
(
replay_name => ‘REPLAY1′,
replay_dir => ‘DIR1′
);
- Prepare the replay
dbms_workload_replay.prepare_replay
(
synchronization => FALSE
);
三.Replay 正式开始:
把capture files 拷贝到本地,假设也拷到d:\capture.
打开cmd.运行命令:wrc Arwen/Arwen@ora11r2 mode = calibrate replaydir=’d:\capture’;
接着运行wrc Arwen/Arwen@ora11r2 mode = replay replaydir = ‘d:\capture’
打开别外一个cmd用sqlplus 连接到db然后运行exec dbms_workload_replay.start_replay.
在前一个cmd中会有提示:replay started :时间 replay finished :时间
Replay完之后生成报表:
DECLARE
l_cap_idNUMBER;
l_rep_idNUMBER;
v_rep_rptCLOB;
REPORTFILE UTL_FILE.FILE_TYPE;
BEGIN
l_cap_id:=dbms_workload_replay.get_replay_info(dir=>'DIR1');
SELECTMAX(id)INTO l_rep_idFROM dba_workload_replays
WHERE capture_id= l_cap_id;
v_rep_rpt:=dbms_workload_replay.report(replay_id=> l_rep_id,format=>'HTML');
REPORTFILE:=UTL_FILE.FOPEN('DIR1','report.HTML','W',32767);
UTL_FILE.PUT_LINE( REPORTFILE, v_rep_rpt,true);
UTL_FILE.FCLOSE(REPORTFILE);
END;
(注:capture完之后在对应的目录中也会生成一个html的report.可以拿来和replay产生的report.html对比).
- Oracle RAT- Real Application Testing
- oracle帮助文档——Real Application Testing User's Guide
- Oracle Real Application Clusters
- Oracle Real Application Cluster
- Oracle Application Testing Suite安装及使用教程
- Oracle Application Testing Suite 12.5.0.2Sample MedRec无法访问问题
- rac(real application cluster)
- Heuristic Web Application Testing
- Oracle WebLogic Server Active GridLink for Oracle Real Application Clusters (RAC) - 1
- Oracle WebLogic Server Active GridLink for Oracle Real Application Clusters (RAC) - 2
- MOS:Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructur
- Penetration Testing in the Real World
- Installing Oracle 9i Real Application Cluster (RAC) on Red Hat Linux Advanced Server 2.1
- 在 WebSphere Process Server 中使用 Oracle Real Application Cluster (RAC)
- What is Split Brain in Oracle Clusterware and Real Application Cluster (Doc ID 1425586.1)
- Oracle Real Application Clusters 11g R2 新特性之SCAN -- 基础篇
- What is Split Brain in Oracle Clusterware and Real Application Cluster (文档 ID 1425586.1)
- Managing Certificates for Application Testing
- Google Protobuf 使用介绍
- 黑马程序员 java中的多线程
- crontab
- Flex企业应用开发实战学习笔记(一)
- 写一个流量采样程序的前后
- Oracle RAT- Real Application Testing
- 用MATLAB做T检验(ttest)
- 关于sql和bigdecimal的除法
- [mysql] 用bat文件执行mysql数据库sql文件
- java开源消息服务(OpenJMS&ActiveMQ)-OpenJMS学习笔记二(运行)
- C语言面试题
- 如何把程序钉到Windows7任务栏(修正版)
- HTTP学习笔记之三——Proxy代理服务器
- GCC使用入门(一)