orabm测试

orabm测试

2009-04-29 16:32

1、下载orabm
2、安装
# Operation Command
1 create the ORABM user (assumes TOOLS tablespace, TEMPtemporary tablespace) sqlplus system/pwd @orabm_user
2 create the tables sqlplus system/pwd @orabm_tab
3 load the data $ orabmload.10g.linux Warehouses 1
4 create the indexes sqlplus system/pwd @orabm_ind
5 analyze the tables and indexes sqlplus system/pwd @orabm_analyze
6 create the stress-test PL/SQL procedures sqlplus system/pwd @orabm_serverside_stress
7 cache the table and index data in the SGA sqlplus system/pwd @orabm_cache
[注]应该是oracle10G的系统，所以执行时需要使用相应 的命令
3、测试
配置，笔记本X61上面的虚拟机
./orabm.10g.linux 1,2,3 20000
---begin sess=1 txn=20000 ORACLE_SID=CBP1 Thu Apr 23 22:57:16 2009
CBP1.REGRESS.RDBMS.DEV.US.ORACLE.COM txn(all)=20000 xn(sam)=15999 t(sam)=23 tps=696 sl=7911(49.4%) on=4806(30%) oi=3282(20.5%) end=230409-22:57:46
---end - Thu Apr 23 22:57:46 2009
---begin sess=2 txn=20000 ORACLE_SID=CBP1 Thu Apr 23 22:57:46 2009
CBP1.REGRESS.RDBMS.DEV.US.ORACLE.COM txn(all)=20000 xn(sam)=15999 t(sam)=42 tps=381 sl=8055(50.3%) on=4748(29.7%) oi=3196(20%) end=230409-22:58:38
CBP1.REGRESS.RDBMS.DEV.US.ORACLE.COM txn(all)=20000 xn(sam)=15999 t(sam)=42 tps=381 sl=7910(49.4%) on=4867(30.4%) oi=3222(20.1%) end=230409-22:58:38
---end - Thu Apr 23 22:58:38 2009
---begin sess=3 txn=20000 ORACLE_SID=CBP1 Thu Apr 23 22:58:38 2009
CBP1.REGRESS.RDBMS.DEV.US.ORACLE.COM txn(all)=20000 xn(sam)=15999 t(sam)=60 tps=267 sl=8032(50.2%) on=4774(29.8%) oi=3193(20%) end=230409-22:59:55
CBP1.REGRESS.RDBMS.DEV.US.ORACLE.COM txn(all)=20000 xn(sam)=15999 t(sam)=64 tps=250 sl=8018(50.1%) on=4797(30%) oi=3184(19.9%) end=230409-22:59:57
CBP1.REGRESS.RDBMS.DEV.US.ORACLE.COM txn(all)=20000 xn(sam)=15999 t(sam)=63 tps=254 sl=7955(49.7%) on=4799(30%) oi=3245(20.3%) end=230409-22:59:57
---end - Thu Apr 23 22:59:57 2009



参考文章：