Oracle stress testing-orabm

Database Pressure Test 1. Use orabm to test the system performance by running a specified number of transactions at the user-specified concurrency. It mainly tests the CPU performance and memory of the database server. Orabm is actually a collection of SQL statements. Orabm can be used in linuxwindowssolaris. Orabm does not need to run in the database

Database Pressure Test 1. Use orabm to test the system performance by running a specified number of transactions at the user-specified concurrency. It mainly tests the CPU performance and memory of the database server. Orabm is actually a collection of SQL statements. Orabm can be used in linux, windows, or solaris. Orabm does not need to run in the database

Database stress testing

1. Use orabm to test the database CPU
Orabm tests the system performance by running a specified number of transactions at a specified concurrency. It mainly tests the CPU performance and memory of the database server.
Orabm is actually a collection of SQL statements.
Orabm can be used in linux, windows, or solaris.
Orabm does not need to run on the server where the database is located. It can run on any terminal installed with the 9i client. You can use a client to connect to a remote database to test the performance of the remote database.

Orabm mainly tests the CPU and memory, so we should try to avoid other factors affecting the test. Therefore, in order to better test the CPU and memory performance when using orabm, it is best to set db_cache_size to a value greater than 200 MB. In this way, all data can be stored in the memory, so that the test is not inaccurate due to physical I/O. One step to use orabm is to put all the tables and indexes in the data buffer.

1. Download Software
Orabm is the http://www.linxcel.co.uk/orabm/orabm.tar for testing CPU

2. Installation
The installation involves 7 steps, corresponding to 6 SQL scripts and a data import tool. All the following scripts can be executed by the new orabm user except the first user with dba permission. To avoid trouble, it is best to use system or sys to run

1) create the ORABM user (assumes TOOLS tablespace, TEMP temporary tablespace)
The first step is to create an orabm user and authorize the user accordingly. Note: by default, orabm uses tools as the default tablespace and temp as the temporary tablespace. The volume of data imported into a Warehouses is about 100 mb. Therefore, you should ensure that the tools tablespace is larger than 150 MB, or create a new tablespace, and then modify the information in orabm_user. SQL.
Sqlplus system/pwd @ orabm_user
Remote database usage:
Sqlplus system/pwd @ tnsname @ orabm_user

2) create the tables
This step mainly creates the tables required for the orabm test.
Sqlplus system/pwd @ orabm_tab
Remote database usage:
Sqlplus system/pwd @ tnsname @ orabm_tag

3) Load the data
Import the data required for the test (orabmload is in the bin directory of the corresponding OS Version)
$ Orabmload Warehouses 1
Remote database usage:
If you want to test a remote database,
For windows, set local = tnsname, which is the alias of the remote database configured in tnsname. ora.
UNIX/LIINUX, TWO_TASK = tnsname first
$ Orabmload Warehouses 1

4) create the indexes
Create an index in this step
Sqlplus system/pwd @ orabm_ind
Remote database usage:
Sqlplus system/pwd @ tnsname @ orabm_ind

5) analyze the tables and indexes
Analysis table and Index
Sqlplus system/pwd @ orabm_analyze
Remote database usage:
Sqlplus system/pwd @ tnsname @ orabm_analyze

6) create the stress-test PL/SQL procedures
Create a stored procedure required for stress testing
Sqlplus system/pwd @ orabm_serverside_stress
Remote database usage:
Sqlplus system/pwd @ tnsname @ orabm_serverside_stress

7) cache the table and index data in the SGA
Put both tables and indexes in SGA. The reason is described above.
Sqlplus system/pwd @ orabm_cache
Remote database usage:
Sqlplus system/pwd @ tnsname @ orabm_cache

After completing these seven steps, the orabm test environment is complete.

3. Test
Now we can perform the test. Set ORACLE_SID and go to the bin directory of the corresponding OS version:
If you test the local database:
$ Orabm 1 20000

If the remote database is tested, run
C:> orabm 1 20000 tnsname
Do not add "@"

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 concurrent tests (corresponding to multiple sessions)
The second parameter indicates how many transactions are executed (Note: not how many transactions are executed concurrently, but the number of transactions executed concurrently). Generally, this value is set to 10000.
The third parameter is used when testing the remote database. The value is the alias for the remote database connection configured in tnsnames. ora.

Orabm 2 1000
2 Concurrent executions of 1000 transactions

Orabm 1000
1, 2, 6, and 19 are used to execute 1000 transactions.

The execution result is printed on the screen and written to the orabm directory where orabm is located. . Log. If the execution is performed multiple times, the execution results will be appended to orabm. . Log.

TPS is the contraction of Transactions Per Second, which is also the number of tasks/Second.
Tps calculation: The tps of all sessions in each stage is the total tps of the current test.

The following is a test example:
The environment configuration is as follows:
CPU P4 2.6
MEM: 1G
OS: WINDOWS XP SP2
DATABASE: 9201
SGA: 300 M
LOGFILE: 100 M
LOG_BUFFER: 3 M

D: programeroracle tools pressure orabmbinwindows> orabm 1000
0
--- Begin sess = 1 txn = 10000 ORACLE_SID = oracle9i Wed Sep 20 17:47:54 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 15 tps = 533 sl = 3966 (49.6%) on = 2478 (31
%) Oi = 1555 (19.4%) end = 200906-17:48:13
--- End-Wed Sep 20 17:48:13 2006
--- Begin sess = 2 txn = 10000 ORACLE_SID = oracle9i Wed Sep 20 17:48:13 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 28 tps = 286 sl = 3933 (49.2%) on = 2436 (30
. 5%) oi = 1630 (20.4%) end = 200906-17:48:48
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 28 tps = 286 sl = 3925 (49.1%) on = 2422 (30
. 3%) oi = 1652 (20.7%) end = 200906-17:48:48
--- End-Wed Sep 20 17:48:48 2006
--- Begin sess = 6 TXT n = 10000 ORACLE_SID = oracle9i Wed Sep 20 17:48:48 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 80 tps = 100 sl = 3978 (49.7%) on = 2415 (30
. 2%) oi = 1606 (20.1%) end = 200906-17:50:28
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 77 tps = 104 sl = 4016 (50.2%) on = 2417 (30
. 2%) oi = 1566 (19.6%) end = 200906-17:50:29
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 79 tps = 101 sl = 4078 (51%) on = 2374 (29.7
%) Oi = 1547 (19.3%) end = 200906-17:50:29
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 86 tps = 93 sl = 3993 (49.9%) on = 2376 (29.
7%) oi = 1630 (20.4%) end = 200906-17:50:31
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 84 tps = 95 sl = 4049 (50.6%) on = 2321 (29%
) Oi = 1629 (20.4%) end = 200906-17:50:31
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 86 tps = 93 sl = 3963 (49.5%) on = 2420 (30.
3%) oi = 1616 (20.2%) end = 200906-17:50:31
--- End-Wed Sep 20 17:50:31 2006
--- Begin sess = 10 txn = 10000 ORACLE_SID = oracle9i Wed Sep 20 17:50:31 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 112 tps = 71 sl = 4005 (50.1%) on = 2391 (29
. 9%) oi = 1603 (20%) end = 200906-17:52:54
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 126 tps = 63 sl = 3994 (49.9%) on = 2433 (30
. 4%) oi = 1572 (19.7%) end = 200906-17:53:05
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 125 tps = 64 sl = 3979 (49.7%) on = 2470 (30
. 9%) oi = 1550 (19.4%) end = 200906-17:53:09
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 131 tps = 61 sl = 4030 (50.4%) on = 2361 (29
. 5%) oi = 1608 (20.1%) end = 200906-17:53:13
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 134 tps = 60 sl = 3992 (49.9%) on = 2390 (29
. 9%) oi = 1617 (20.2%) end = 200906-17:53:14
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 135 tps = 59 sl = 3998 (50%) on = 2352 (29.4
%) Oi = 1649 (20.6%) end = 200906-17:53:15
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 138 tps = 58 sl = 3962 (49.5%) on = 2421 (30
. 3%) oi = 1616 (20.2%) end = 200906-17:53:17
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 138 tps = 58 sl = 3999 (50%) on = 2412 (30.2
%) Oi = 1588 (19.9%) end = 200906-17:53:17
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 136 tps = 59 sl = 3988 (49.9%) on = 2484 (31
. 1%) oi = 1527 (19.1%) end = 200906-17:53:18
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 143 tps = 56 sl = 3992 (49.9%) on = 2365 (29
. 6%) oi = 1642 (20.5%) end = 200906-17:53:18
--- End-Wed Sep 20 17:53:18 2006
--- Begin sess = 15 TXT n = 10000 ORACLE_SID = oracle9i Wed Sep 20 17:53:18 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 168 tps = 48 sl = 4029 (50.4%) on = 2377 (29
. 7%) oi = 1593 (19.9%) end = 200906-17:56:51
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 170 tps = 47 sl = 4023 (50.3%) on = 2406 (30
. 1%) oi = 1570 (19.6%) end = 200906-17:56:52
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 172 tps = 47 sl = 3932 (49.2%) on = 2484 (31
. 1%) oi = 1583 (19.8%) end = 200906-17:57:01
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 191 tps = 42 sl = 4014 (50.2%) on = 2461 (30
. 8%) oi = 1524 (19.1%) end = 200906-17:57:17
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 198 tps = 40 sl = 3993 (49.9%) on = 2396 (30
%) Oi = 1610 (20.1%) end = 200906-17:57:19
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 192 tps = 42 sl = 4000 (50%) on = 2392 (29.9
%) Oi = 1607 (20.1%) end = 200906-17:57:19
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 202 tps = 40 sl = 3996 (50%) on = 2390 (29.9
%) Oi = 1613 (20.2%) end = 200906-17:57:21
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 195 tps = 41 sl = 4023 (50.3%) on = 2365 (29
. 6%) oi = 1611 (20.1%) end = 200906-17:57:21
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 200 tps = 40 sl = 3962 (49.5%) on = 2411 (30
. 1%) oi = 1626 (20.3%) end = 200906-17:57:21
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 203 tps = 39 sl = 4039 (50.5%) on = 2385 (29
. 8%) oi = 1575 (19.7%) end = 200906-17:57:21
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 198 tps = 40 sl = 3998 (50%) on = 2406 (30.1
%) Oi = 1595 (19.9%) end = 200906-17:57:22
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 204 tps = 39 sl = 4025 (50.3%) on = 2364 (29
. 6%) oi = 1610 (20.1%) end = 200906-17:57:22
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 208 tps = 38 sl = 3944 (49.3%) on = 2475 (30
. 9%) oi = 1580 (19.8%) end = 200906-17:57:23
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 201 tps = 40 sl = 3944 (49.3%) on = 2448 (30
. 6%) oi = 1607 (20.1%) end = 200906-17:57:23
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 217 tps = 37 sl = 3960 (49.5%) on = 2451 (30
. 6%) oi = 1588 (19.9%) end = 200906-17:57:24
--- End-Wed Sep 20 17:57:24 2006
----- Begin sess = 20 txn = 10000 ORACLE_SID = oracle9i Wed Sep 20 17:57:24 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 208 tps = 38 sl = 4033 (50.4%) on = 2308 (28
. 9%) oi = 1658 (20.7%) end = 200906-18:01:49
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 254 tps = 31 sl = 4093 (51.2%) on = 2382 (29
. 8%) oi = 1524 (19.1%) end = 200906-18:02:41
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 257 tps = 31 sl = 3988 (49.9%) on = 2416 (30
. 2%) oi = 1595 (19.9%) end = 200906-18:02:41
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 252 tps = 32 sl = 4088 (51.1%) on = 2375 (29
. 7%) oi = 1536 (19.2%) end = 200906-18:02:42
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 260 tps = 31 sl = 3970 (49.6%) on = 2422 (30
....

Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 272 tps = 29 sl = 4005 (50.1%) on = 2402 (30
%) Oi = 1592 (19.9%) end = 200906-18:02:55
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 280 tps = 29 sl = 4002 (50%) on = 2420 (30.3
%) Oi = 1577 (19.7%) end = 200906-18:02:55
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 276 tps = 29 sl = 3981 (49.8%) on = 2428 (30
. 4%) oi = 1590 (19.9%) end = 200906-18:02:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 289 tps = 28 sl = 3974 (49.7%) on = 2399 (30
%) Oi = 1626 (20.3%) end = 200906-18:02:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 276 tps = 29 sl = 4027 (50.3%) on = 2379 (29
. 7%) oi = 1593 (19.9%) end = 200906-18:02:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 272 tps = 29 sl = 4031 (50.4%) on = 2399 (30
%) Oi = 1569 (19.6%) end = 200906-18:02:56
--- End-Wed Sep 20 18:02:56 2006
--- Begin sess = 25 txn = 10000 ORACLE_SID = oracle9i Wed Sep 20 18:02:56 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 235 tps = 34 sl = 3996 (50%) on = 2414 (30.2
%) Oi = 1589 (19.9%) end = 200906-18:07:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 242 tps = 33 sl = 3997 (50%) on = 2408 (30.1
%) Oi = 1594 (19.9%) end = 200906-18:07:57
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 308 tps = 26 sl = 4058 (50.7%) on = 2387 (29
. 8%) oi = 1554 (19.4%) end = 200906-18:09:16
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 305 tps = 26 sl = 3959 (49.5%) on = 2433 (30
. 4%) oi = 1607 (20.1%) end = 200906-18:09:17
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 307 tps = 26 sl = 4051 (50.6%) on = 2387 (29
. 8%) oi = 1561 (19.5%) end = 200906-18:09:26
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 327 tps = 24 sl = 3972 (49.7%) on = 2444 (30
. 6%) oi = 1583 (19.8%) end = 200906-18:09:26
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 330 tps = 24 sl = 4022 (50.3%) on = 2387 (29
. 8%) oi = 1590 (19.9%) end = 200906-18:09:27
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 312 tps = 26 sl = 3973 (49.7%) on = 2413 (30
. 2%) oi = 1613 (20.2%) end = 200906-18:09:29
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 320 tps = 25 sl = 4050 (50.6%) on = 2378 (29
. 7%) oi = 1571 (19.6%) end = 200906-18:09:30
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 314 tps = 25 sl = 4005 (50.1%) on = 2366 (29
. 6%) oi = 1628 (20.4%) end = 200906-18:09:30
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 314 tps = 25 sl = 4005 (50.1%) on = 2366 (29
. 6%) oi = 1628 (20.4%) end = 200906-18:09:30
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 332 tps = 24 sl = 3965 (49.6%) on = 2409 (30
. 1%) oi = 1625 (20.3%) end = 200906-18:09:30
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 317 tps = 25 sl = 3997 (50%) on = 2424 (30.3
%) Oi = 1578 (19.7%) end = 200906-18:09:32
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 316 tps = 25 sl = 3970 (49.6%) on = 2384 (29
. 8%) oi = 1645 (20.6%) end = 200906-18:09:33
....

Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 350 tps = 23 sl = 3966 (49.6%) on = 2449 (30
. 6%) oi = 1584 (19.8%) end = 200906-18:09:41
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 350 tps = 23 sl = 4030 (50.4%) on = 2328 (29
. 1%) oi = 1641 (20.5%) end = 200906-18:09:42
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 353 tps = 23 sl = 4027 (50.3%) on = 2414 (30
. 2%) oi = 1558 (19.5%) end = 200906-18:09:43
--- End-Wed Sep 20 18:09:43 2006
--- Begin sess = 30 txn = 10000 ORACLE_SID = oracle9i Wed Sep 20 18:09:43 2006
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 286 tps = 28 sl = 3942 (49.3%) on = 2392 (29
. 9%) oi = 1665 (20.8%) end = 200906-18:15:35
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 288 tps = 28 sl = 4001 (50%) on = 2396 (30%)
Oi = 1602 (20%) end = 200906-18:15:44
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 286 tps = 28 sl = 3912 (48.9%) on = 2444 (30
. 6%) oi = 1643 (20.5%) end = 200906-18:15:51
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 373 tps = 21 sl = 4007 (50.1%) on = 2408 (30
. 1%) oi = 1584 (19.8%) end = 200906-18:17:24
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 372 tps = 22 sl = 4012 (50.2%) on = 2375 (29
. 7%) oi = 1612 (20.2%) end = 200906-18:17:25
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 371 tps = 22 sl = 3987 (49.8%) on = 2386 (29
....

Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 384 tps = 21 sl = 4020 (50.3%) on = 2389 (29
. 9%) oi = 1590 (19.9%) end = 200906-18:17:44
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 395 tps = 20 sl = 4002 (50%) on = 2418 (30.2
%) Oi = 1579 (19.7%) end = 200906-18:17:44
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 394 tps = 20 sl = 4037 (50.5%) on = 2406 (30
. 1%) oi = 1556 (19.5%) end = 200906-18:17:45
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 390 tps = 21 sl = 3959 (49.5%) on = 2389 (29
. 9%) oi = 1651 (20.6%) end = 200906-18:17:45
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 395 tps = 20 sl = 3978 (49.7%) on = 2409 (30
. 1%) oi = 1612 (20.2%) end = 200906-18:17:47
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 409 tps = 20 sl = 3988 (49.9%) on = 2393 (29
. 9%) oi = 1618 (20.2%) end = 200906-18:17:49
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 391 tps = 20 sl = 4005 (50.1%) on = 2407 (30
. 1%) oi = 1587 (19.8%) end = 200906-18:17:51
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 387 tps = 21 sl = 4024 (50.3%) on = 2433 (30
. 4%) oi = 1542 (19.3%) end = 200906-18:17:53
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 394 tps = 20 sl = 3962 (49.5%) on = 2407 (30
. 1%) oi = 1630 (20.4%) end = 200906-18:17:54
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 404 tps = 20 sl = 3991 (49.9%) on = 2371 (29
. 6%) oi = 1637 (20.5%) end = 200906-18:17:54
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 402 tps = 20 sl = 4066 (50.8%) on = 2386 (29
. 8%) oi = 1547 (19.3%) end = 200906-18:17:54
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 409 tps = 20 sl = 3943 (49.3%) on = 2545 (31
. 8%) oi = 1511 (18.9%) end = 200906-18:17:55
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 399 tps = 20 sl = 4013 (50.2%) on = 2422 (30
. 3%) oi = 1564 (19.6%) end = 200906-18:17:55
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 415 tps = 19 sl = 3964 (49.6%) on = 2425 (30
. 3%) oi = 1610 (20.1%) end = 200906-18:17:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 415 tps = 19 sl = 3982 (49.8%) on = 2408 (30
. 1%) oi = 1609 (20.1%) end = 200906-18:17:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 407 tps = 20 sl = 4017 (50.2%) on = 2431 (30
. 4%) oi = 1551 (19.4%) end = 200906-18:17:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 427 tps = 19 sl = 4024 (50.3%) on = 2368 (29
. 6%) oi = 1607 (20.1%) end = 200906-18:17:56
Oracle9i txn (all) = 10000 xn (sam) = 7999 t (sam) = 420 tps = 19 sl = 4000 (50%) on = 2397 (30%)
Oi = 1602 (20%) end = 200906-18:17:57
--- End-Wed Sep 20 18:17:57 2006

Where:
Txn (all) ---- represents Total transaction Count, the Total number of transactions.
Xn (sam) ----- Number of sampled transactions
T (sam) ------ sample the transaction running time.

This result is too messy. We can use orabm_tps.sh, the script provided by orabm, to format it:
This script is generally available in linux. I have installed some linux Enhancement tools on my machine in windows, so I can run this script normally.
D: programeroracle tools pressure orabmbin> orabm_tps.sh orabm. oracle9i. log
ORACLE_SID = oracle9i sess = 1 tps = 500
ORACLE_SID = oracle9i sess = 3 tps = 576
ORACLE_SID = oracle9i sess = 1 tps = 533
ORACLE_SID = oracle9i sess = 2 tps = 572
ORACLE_SID = oracle9i sess = 6 tps = 586
ORACLE_SID = oracle9i sess = 10 tps = 609
ORACLE_SID = oracle9i sess = 15 tps = 620
ORACLE_SID = oracle9i sess = 20 tps = 610
ORACLE_SID = oracle9i sess = 25 tps = 1, 631
ORACLE_SID = oracle9i sess = 30 tps = 632

Do not execute other programs. Normally, no matter how many concurrent programs are executed, the CPU usage should be at 100%.
The results show that the tps of the local machine is about 610.

Not the more concurrency, the larger the tps, sometimes the tps decreases as the concurrency increases.
If the tps does not increase significantly or decreases as the concurrency increases, the system bottleneck is reached. This critical point can be seen as the maximum tps that the system can afford.