Use the open-source tool orabm to calculate the TPS value to test the server CPU Performance

Test Platform: RHEL4.8x8 _ 64 + OracleDatabase10.2.0.41) tool description orabm is an open-source system CPU performance testing tool that contains a set of SQL scripts and several command line programs. orabm runs a specified number of transactions at a specified concurrency to test the TPS value of the database. TPS is the abbreviation of TransactionsPerSecond,

Test Platform: RHEL4.8 x8_64 + Oracle Database 10.2.0.4

1)Tool description

 

Orabm is an open-source system CPU performance testing tool that includes a set of SQL scripts and severalCommandProgram. orabm runs a specified number of transactions at a specified concurrency to test the TPS value of the database. TPS is the abbreviation of Transactions Per Second, that is, the number of Transactions Per Second. It is the measurement unit of the software test result. A transaction refers to the process in which a client sends a request to the server and then the server responds. the client starts timing when sending the request and ends timing after receiving the server response. This is used to calculate the time used and the number of completed transactions, and finally uses this information to estimate the score.

 

2)Download and install

 

OrabmDownloadAddress:

Free onHttp://linux.linuxIdC.com/

Both the user name and password areWww.linuxidc.com

The specific download directory is in/Pub/2011/08/17/use the open-source tool orabm to calculate the TPS value to test the server CPU performance/

Then

 

$Cd/Orahome/wangNc/OS/

$ Rz

$ Tar xvf orabm.tar

$ Cd install

$Ls

Orabm_analyze. SQL orabm_cache. SQL orabm_ind. SQL orabm_query_cache. SQL orabm_serverside_sTrEss. SQL orabm_tab _Rm. SQL orabm_tab. SQL orabm_user. SQL _ vti_cnf

Note: The default orabm test will be created in the tools tablespace. If you want to put the data in another tablespace, you can modify orabm_user. SQL to adjust it.

$ Vi orabm_user. SQL

$ Sqlplus/as sysdba @ orabm_user. SQL

$ Sqlplus/as sysdba @ orabm_tab. SQL

$ExPort LD_LIBRARY_PATH = $ ORACLE_HOME/lib32: $ LD_LIBRARY_PATH

$ChmodU + x ../bin/linux/orabmload.10g. linux

$ ../Bin/linux/orabmload.10g. linux Warehouses 1

$ Sqlplus/as sysdba @ orabm_ind. SQL

$ Sqlplus/as sysdba @ orabm_analyze. SQL

$ Sqlplus/as sysdba @ orabm_serverside_stress. SQL

$ Sqlplus/as sysdba @ orabm_cache. SQL

 

3)Simple Test

 

Orabm is followed by two parameters (if the stress test is remote, it is followed by three parameters). The first parameter indicates the number of concurrency tests (corresponding to multiple sessions ), the second parameter indicates the number of transactions to be executed (not the total number of transactions to be executed concurrently, but the number of transactions to be executed concurrently). Generally, this value is set to 10000, the third parameter is used to test the remote database. The value is tnsnames. the alias for the remote database connection configured by ora.

 

$Cd ../bin/linux/

$Chmod u + x orabm.10g. linux

$./Orabm.10g. linux 1 10000

--- Begin sess = 1 txn = 10000 ORACLE_SID = ESUITE Tue Jul 14 13:36:18 2009

ESUITE. LK txn (all) = 10000 xn (sam) = 7999 t (sam) = 3Tps = 2666Sl = 3980 (49.8%) on = 2367 (29.6%) oi = 1652 (20.7%) end = 140709-13:36:23

--- End-Tue Jul 14 13:36:23 2009

 

Description of output results:

Txn (all) ---- represents Total transaction Count, Total number of transactions

Xn (sam) ----- Number of sampled transactions

T (sam) ------ sample the transaction running time

Tps calculation: The tps of all sessions in each stage is the total tps of the current test.

 

The execution result is printed on the screen and an orabm is generated. $ {ORACLE_SID }. log file, which is accumulated. if all the test tables and related indexes have been cached in the memory and no other tasks are running on the system, we can see that a single Orabm Session will use nearly 100% of the CPU resources. you can use Top to view CPU usage or check whether \ "db does not exist in the database.FileSequential read \ "Wait For event.