-
-
-
超过十年Oracle数据库管理经验,擅长Oracle数据库诊断、优化。擅长产品包括 Oracle Database,RAC,RAT,ADG,Exadata,EM12c等
Gtalk&Mail: ricky.zhu#gmail.com Meta
-
Recent
Archive
- March 2016 (1)
- January 2016 (1)
- January 2014 (1)
- November 2013 (1)
- October 2013 (1)
- August 2013 (1)
- July 2013 (1)
- June 2013 (1)
- April 2013 (1)
- March 2013 (1)
- January 2013 (1)
- December 2012 (1)
- August 2012 (1)
- June 2012 (2)
- March 2012 (1)
- February 2012 (1)
- January 2012 (1)
- December 2011 (4)
- November 2011 (5)
- October 2011 (1)
- September 2011 (2)
- August 2011 (1)
- June 2011 (1)
- May 2011 (2)
- January 2011 (2)
- November 2010 (2)
- October 2010 (3)
- September 2010 (2)
- August 2010 (2)
- July 2010 (5)
- June 2010 (1)
- May 2010 (6)
- April 2010 (3)
- March 2010 (4)
- February 2010 (2)
- January 2010 (4)
- December 2009 (4)
- November 2009 (6)
- October 2009 (6)
- September 2009 (8)
- August 2009 (3)
- July 2009 (7)
- June 2009 (5)
- May 2009 (2)
- April 2009 (7)
- March 2009 (9)
- February 2009 (8)
- January 2009 (3)
- December 2008 (4)
- November 2008 (5)
- October 2008 (8)
- September 2008 (9)
- August 2008 (8)
- July 2008 (3)
- June 2008 (11)
- May 2008 (6)
- April 2008 (4)
- March 2008 (5)
- February 2008 (12)
- January 2008 (15)
- December 2007 (14)
- November 2007 (21)
- October 2007 (15)
- September 2007 (11)
- August 2007 (19)
- July 2007 (17)
- June 2007 (18)
- May 2007 (39)
- April 2007 (43)
- March 2007 (61)
- February 2007 (32)
- January 2007 (11)
- December 2006 (15)
Category
Oracle相关网站
博客圈子
数据库圈子
测试圈子
测试网站
Visitor
Tag Archives: RAT
打开Oracle 10g的Real Application Testing功能
Oracle 自11gR1开始提供了一个极好的feature– Real Application Testing,又叫做数据库回放。可以通过内置于数据库中的捕捉功能从数据库层面把所有的业务操作录制下来,并拿到适当的环境进行回放。这个对于想要模拟实际生产环境的负载来说,实在是非常有用的特性。传统的在测试环境要想模拟生产负载一般通过挑选典型场景,使用测试工具(如LoadRunner或者JMeter)或者编码的形式准备好测试脚本,然后进行加压,耗时长而且误差不可估计。 RAT因为是内置于数据库本身,所有就具有与生俱来的优势了。 除此之外,对于数据库的升级,软硬件架构变化等等各种变化可能对数据库带来的影响,RAT也是极好的一个衡量手段。在老的系统上录制下来的工作负载,拿到变更后的环境进行回放,就可以很好的看出变更带来的差异,性能的提升或者衰减。 之前介绍过RAT的使用方法,今天主要介绍如何在老版本上打开RAT功能。 10.2.0.4之前的版本,需要打一个补丁,然后再运行必须的程序包进行激活。10.2.0.4之后的版本,因为本身已经具备了RAT功能,所以只需要修改一个数据库参数即可。(之所以这个参数从10.2.0.4开始才有是因为11gR1发布的时候10.2.0.4尚未发布,所以这个feature就被backport进去了)。 10.2.0.2或者更老的版本有一个特殊之处是补丁打完,捕捉的时候还会报错,现象就是: ERROR at line 1: ORA-04063: package body “SYS.DBMS_WORKLOAD_CAPTURE” has errors ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_WORKLOAD_CAPTURE” ORA-06512: at line 1 这个问题在bug#9094202中描述,这个bug可以通过替换之前版本的prvtawr.plb文件进行绕过。这个问题在10.2.0.3修复了。 P.S. 还有不到10个小时2012年就要结束了,今年太懒了,总共不到10篇博文,来年得好好反省反省。顺便祝本站的新老读者朋友新年开心! BTW:玛雅人的预测太不靠谱了!他们预言的世界末日那一刻,我刚好在客户现场解决刚才的这个bug,等到搞定之后,旁边的哥们告诉我,世界末日已经过了,我立时有种劫后余生的感觉!!