-
-
-
超过十年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
Daily Archives: July 19, 2009
开源数据库性能测试工具HammerOra介绍
.!. 前段时间发现了这个工具,并粗略研究了一下,工具是基于TCL(Tool Command Language)语言的(我之前用Tcl工作过好几年,之前自动化框架就是基于Tcl来开发的,Tcl是非常优秀的自动化脚本语言) 首先HammerOra 是一款负载测试工具 其次HammerOra目前支持Oracle, MySQL和HTTP应用(web应用) 然后HammerOra是开源的,框架有点类似于商业工具LoadRunner 因为HammerOra是基于Tcl语言的,所以天生就是可移植的,可以运行于Windows平台和Linux平台。 HammerOra内嵌了两套标准测试脚本 tpc-c and tpc-h,当然你也可以自己开发和扩充测试脚本,开发语言是Tcl HammerOra包含三个部分(这点有点类似于LoadRunner)创建测试脚本(打开build-in的tpc-c or tpc-h)然后可以进行调试;配置并创建虚拟用户,并设置虚拟用户的策略,比如持续时间,用户迭代,rumpup原则等,然后控制场景运行;最后是监控事物计数器。对应于LoadRunner分别是VUGen, Controller and Analysis HammerOra的工作原理就是捕捉Oracle的trace文件,并生成相应的SQL脚本进行回放,所以对用户的场景模拟程度是非常高的。HammerOra跟Oracle的接口是也是利用一个Tcl的package OraTcl来完成的。(之前我们在开发测试平台时,后台驱动Oracle数据库操作也是通过这个package来完成的;记得我面试oracle第一个职位的时候,美国的同事还问到关于这个Package的几个问题) HammerOra的安装非常简单,一种是源码安装,还是就是安装包安装,就不多做介绍了,可以参考官方文档。 如果你要对数据库进行性能测试,预算有限的话,可以考虑这款优秀的开源工具。 脚本界面: 场景界面: 结果界面: