Orabm works by running a user-specified number of database transactions in each of a user-specified number of concurrent database sessions. Orabm通过在用户指定的并发下运行指定数量的事务来测试系统性能. The transactions are executed by the ORABM_SERVERSIDE_STRESS stored procedure, under the schema ORABM. 事务通过执行orabm用户的ORABM_SERVERSIDE_STRESS过程来实现.
For each concurrent session, ORABM_SERVERSIDE_STRESS runs the number of transactions specified on the orabm command line, and returns the transactions per second (TPS) value for that session during the sampling interval on completion. 对于每个并发session,ORABM_SERVERSIDE_STRESS运行在orabm命令行指定数量的事务. 并返回在完成所有任务的采样间隔内每秒的事务数量. To ensure that all concurrent sessions are processing transactions during the sampling interval, the TPS value only includes results from the middle 80% of transactions: the first 10% and last 10% are ignored. 为了保证准确性,TPS值只取中间的80%数据,头尾的10%都将被忽略.
The transactions are loosely based on the TPC-C Order-Status and Stock-Level transactions, using a predefined distribution of transactions. 事务是松散的,基于标准的TPC-C测试的订单、库存事务模型,使用预定义的事务分布. The transaction split, which is based on data returned by the DBMS_RANDOM package, should be: 事务基于DBMS_RANDOM包的返回值进行分割,应该是:
The string returned by ORABM_SERVERSIDE_STRESS includes the transaction split during the test, to ensure that the transaction distribution is correct, subject to random fluctuations e.g.: 为了确保事务分布的正确性,ORABM_SERVERSIDE_STRESS的输出包含事务分割比例,输出结果具有随机波动,例如:
Once you have set up the test tables, data, and indexes, you're ready to run orabm. The following command shows orabm running 20000 transactions in a single session against the Oracle database identified by ORACLE_SID in the UNIX environment: 在成功安装了orabm之后,在UNIX下定义好了ORACLE_SID环境变量之后,我们可以如下运行orabm命令进行测试:
$ orabm 1 20000
This command line runs the same workload against a remote database identified by the Oracle Net alias linxceld1.co.uk from a Windows command box: 以下是在WINDOWS下远程运行方式:
精品推荐