Original link:
http://www.eygle.com/special/USE.ORABM.2.Test.system.cpu.htm
ORABM is an open source system CPU performance test tool.
ORABM installation you can refer to:
How to install ORABM
Author's original page is as follows:
http://linxcel.co.uk/orabm/orabm.htm
Let's take a look at how to use ORABM to test CPU performance through the Oracle database.
1. First, let's first understand the principle of ORABM:
How Orabm Works
Orabm works by running a user-specified number of database transactions in each of a user-specified number of concurrent database sessions. Orabm to test the performance of the system by running .The transactions specified in the user specified number of concurrent transactions are executed by the ORABM_SERVERSIDE_STRESS Stored Procedure, Under The Schema ORABM. Transaction is implemented by executing ORABM_SERVERSIDE_STRESS procedures for ORABM users.
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. For each concurrent session, ORABM_SERVERSIDE_STRESS run command orabm Specifies the number of transactions and returns the number of transactions per second in the sampling interval to complete all tasks .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. In order to ensure accuracy, the TPS value takes only 80% data in the middle, and 10% of the head will be ignored.
The Transactions Are Loosely Based On The TPC-C Order-Status and stock-level transactions, using a predefined distribution of transactions. The transaction is loose, standard-based TPC-C test orders, inventory transactions, using predefined transactions Distribution .The Transaction Split, Which Is Based on Data Returned by the dbms_random package, Should Be: Transaction Based on the return value of the DBMS_RAndom package, it should be:
Stock-level: Order-by-customer-name: Order-by-customer-id50%: 30%: 20%
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 eg: In order to ensure the correctness of the distributed transaction, including the divided output ORABM_SERVERSIDE_STRESS proportion of the transaction, the output of random fluctuations, For example: ... SL = 4042 (50.5%) ON = 2384 (29.8%) Oi = 1573 (19.7%) ...
ORABM COMMAND LINE
Once you have set up the test tables, data, and indexes,'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:. In successfully installed After ORABM, after the Oracle_SID environment variable is defined under UNIX, we can run the ORABM command with the following:
$ ORABM 1 20000
This Command Line Runs The Same Workload Against A Remote Database Identified by the Oracle Net Alias Linxceld1.uk from A Windows Command Box: The following is a remote operation mode under Windows:
C: /> ORABM 1 20000 Linxceld1.co.uk
NOTE: Running Against a Remote Database Has Little (if any), Affect On The Transaction Throughput, Because All Processing Takes Place on The DBMS Server.
Execution of a single Orabm session should show a single CPU at close to 100% utilization, provided that all table and index data is present in the Oracle block buffer cache and no other workload is running on the database server. On UNIX or Linux, you can use the "top" command to confirm this, or check that no "db file sequential read" event waits are taking place for the Oracle session using info in the V $ SESSION_EVENT view - these indicate waits for physical I / O.
If all test forms and related index have cache to memory, there is no other task to run on the system, then you can see that a single ORABM Session will use nearly 100% CPU resources. On Linux or Unix, you can use top to view CPU usage, or no "DB File Sequential Read" wait event in the procuratorial database.
Alternatively, if your Oracle DBMS is running on Linux, you can use the gkrellm performance monitor to show that CPU utilization of a single CPU is at ~ 100% and no physical I / O is taking place Gkrellm can be downloaded from:. Http: //web.wt.net/~billw/gkrellm/gkrellm.html
Here's an example of the command line you would use to run 10000 transactions against a local Oracle database for three iterations. In the first iteration, one session runs, in the second iteration two concurrent sessions run, and in the third iteration, six concurrent sessions Run:
The following is a test example, three stages of testing of the local database, and perform 10,000 transactions in 1, 2, 6 concurrently.
$ ORABM 1,2,6 10000
Keep In Mind That The Specified Number of Transactions Is Run in Each Concurrent Session.
Note that 10,000 transactions defined here are for each session.
Note: You Should Specify Sufficient Transactions Such That The Tps Results Productly Between Runs for a Given Number of Sessions; 100000 is A Good Value To choise.
Note: You should define enough transactions so that the TPS results are small in different quantities, usually 100,000 is a good choice.
Results Output
Output is appended to a log file orabm.database.log, where database is either the ORACLE_SID or TNS alias that identifies the database where the test was run eg orabm.t92.log. For each iteration, the TPS value for each concurrent session appears between begin and end markers for example, the following shows the contents of the log for two concurrent sessions -. in this case the second iteration for the previous command line example - where txn (all) displays the total transaction count, and xn (sam ) and TOUW THE TOTAL Transactions and Time for the Middle 80% of Transactions for Which Sampling Took Place:
Description of the output: TXN (ALL) ---- represents Total Transaction Count, the total transaction number .xn (sam) ------ Sampling Transaction Quantity T (SAM) ------ Sampling Transaction time.
--- Begin sess = 2 TXN = 10000 oracle_sid = T92 FRI NOV 8 20:31:48 2002t92.world TXN (AL) = 10000 xn (SAM) = 7999 T (SAM) = 44 TPS = 182 ... T92. World TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 45 TPS = 178 ...-- end - fri nov 8 20:32:46 2002the total tps for this ity is the sum of the TPS For the Two Concurrent Sessions (182 178 = 360). For the above output, in 2 concurrent, the TPS value is 182 178 = 360
A shell script (orabm_tps.sh) can be used to process output from the log on UNIX and Linux. The script aggregates the TPS values for concurrent sessions in a single iteration into a total TPS value for that iteration. The output based on the log Info from The Previous Command Line (3 Itemions with 1, THEN 2, THEN 6 Concurrent Sessions) shows: You can also use Shell Script (ORABM_TPS.SH) to output log analysis.
$ ORABM_TPS.SH ORABM.T92.Logoracle_sid = T92 sess = 1 TPS = 182racle_sid = T92 sess = 2 TPS = 360ORACLE_SID = T92 sess = 6 TPS = 364
In this example, Server has two CPUs in this example, and two of the tests are sufficient to consume all. CPU resource.
Additional sessions should result in the total TPS remaining unchanged, or even falling slightly as the operating system performs context switches to share the overloaded CPU resource between more ready-to-run sessions than available CPUs. Continue to increase concurrency and TPS does not lead to an increase worth And it may even fall.
2. Look at my test results
$ ORABM 1,2,6,10,15,20,25,30,100000
- Begin sess = 1 txn = 10000 oracle_sid = HSBILL Sun SEP 26 00:51:34 2004HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 89 TPS = 90 SL = 3915 (48.9%) ON = 2481 (31%) Oi = 1603 (20%) end = 260904-00: 53: 25 --- End - Sun Sep 26 00:53:25 2004 - Begin sess = 2 Txn = 10000 oracle_sid = HSBILL SUN SEP 26 00:53:25 2004HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 96 TPS = 83 SL = 3992 (49.9%) ON = 2464 (30.8%) Oi = 1543 (19.3%) end = 260904-00: 55: 25hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 104 TPS = 77 SL = 3945 (49.3%) ON = 2404 (30.1%) OI = 1650 (20.6%) end = 260904-00: 55: 34 --- End - Sun Sep 26 00:55:34 2004 --- Begin sess = 6 TXN = 10000 oracle_sid = HSBILL SUN SEP 26 00:55:34 2004HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 189 TPS = 42 SL = 4039 (50.5%) ON = 2332 (29.2%) Oi = 1628 (20.4%) end = 260904-00: 59: 32hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 193 TPS = 41 SL = 3999 (50%) OI = 2402 (30%) Oi = 1598 (20%) end = 260904-00: 59: 36HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (sam) = 7999 T (SAM ) = 192 TPS = 42 SL = 3933 (49.2%) ON = 24 35 (30.4%) Oi = 1631 (20.4%) end = 260904-00: 59: 36HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 198 TPS = 40 SL = 4033 (50.5%) OI = 2358 (29.5%) Oi = 1608 (20.1%) end = 260904-00: 59: 38HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 201 TPS = 40 SL = 4027 (50.3%) ON = 2339 (29.2%) Oi = 1633 (20.4%) end = 260904-00: 59: 40HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 202 TPS = 40 SL = 3998 (50%) ON = 2454 (30.7%) Oi = 1547 (19.3%) end =
260904-00: 59: 42 --- End - Sun Sep 26 00:59:42 2004 --- Begin sess = 10 TXN = 10000 oracle_sid = HSBILL Sun SEP 26 00:59:42 2004HSBILL.HURRAY.com.cn TXN (all) = 10000 xn (sam) = 7999 t (sam) = 277 TPS = 29 SL = 3951 (49.6%) OI = 1602 (20%) end = 260904-01: 05: 24HSBILL .Hurray.com.cn TXN (ALL) = 10000 XN (SAM) = 7999 T (SAM) = 287 TPS = 28 SL = 3993 (49.9%) OI = 1594 (19.9%) end = 260904-01: 05: 39HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 287 TPS = 28 SL = 3965 (49.6%) ON = 2390 (29.9%) OI = 1644 (20.6%) end = 260904-01: 05: 43hsbill.hurray.com.cn TXN (AL) = 10000 xn (sam) = 7999 t (sam) = 288 TPS = 28 SL = 3944 (49.3%) ON = 2472 (30.9%) OI = 1583 (19.8%) end = 260904-01: 05: 43Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 290 TPS = 28 SL = 4106 (51.3%) OI = 2294 (28.7%) Oi = 1599 (20%) end = 260904-01: 05: 44hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 293 TPS = 27 SL = 4040 (50.5%) OI = 2397 (30%) Oi = 1562 (19.5%) end = 260904-01: 05: 44HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 292 TPS = 27 SL = 3950 (49.4%) ON = 2438 (30.5%) OI = 161 1 (20.1%) end = 260904-01: 05: 46HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (sam) = 7999 T (SAM) = 295 TPS = 27 SL = 4006 (50.1%) ON = 2430 (30.4%) OI = 1563 (19.5%) end = 260904-01: 05: 47HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 301 TPS = 27 SL = 4008 (50.1%) OI = 2362 (29.5%) end = 1629 (20.4%) end = 260904-01: 05: 48Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (SAM) = 301 TPS = 27 SL = 3984 (49.5%) OI = 1652 (20.7%) end =
260904-01: 05: 49 --- End - Sun Sep 26 01:05:49 2004 --- Begin sess = 15 TXN = 10000 oracle_sid = HSBILL SUN SEP 26 01:05:49 2004HSBILL.HURRAY.com.cn TXN (all) = 10000 xn (sam) = 7999 T (SAM) = 398 TPS = 20 SL = 4050 (50.6%) ON = 2379 (29.7%) Oi = 1570 (19.6%) end = 260904-01: 14: 14Hsbill .Hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 402 TPS = 20 SL = 4024 (50.3%) ON = 2366 (29.6%) Oi = 1609 (20.1%) end = 260904-01: 14: 14HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 408 TPS = 20 SL = 4032 (50.4%) ON = 2326 (29.1%) OI = 1641 (20.5%) end = 260904-01: 14: 15HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (sam) = 7999 T (SAM) = 408 TPS = 20 SL = 4007 (50.1%) ON = 2355 (29.4%) Oi = 1637 (20.5%) end = 260904-01: 14: 15Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 402 TPS = 20 SL = 4071 (50.9%) OI = 2377 (29.7%) end = 260904-01: 14: 15Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 408 TPS = 20 SL = 4055 (50.7%) OI = 2385 (19.5%) end = 260904-01: 14: 17HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 415 TPS = 19 SL = 3963 (49.5%) ON = 2424 (30.3%) Oi = 1612 (20.2%) end = 260904-01: 14: 22hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 407 TPS = 20 SL = 4061 (50.8%) ON = 2337 (29.2%) Oi = 1601 (20%) end = 260904-01: 14: 23hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 416 TPS = 19 Sl = 3900 (48.8%) OI = 2404 (21.2%) end = 260904-01: 14: 25hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 t SAM) = 421 TPS = 19 SL = 3942 (49.3%) ON = 2442 (30.5%) Oi = 1615 (20.2%) end =
260904-01: 14: 26HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 417 TPS = 19 SL = 3966 (49.6%) ON = 2432 (30.4%) OI = 1601 (20%) end = 260904-01: 14: 26HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 427 TPS = 19 SL = 4039 (50.5%) ON = 2383 (29.8%) Oi = 1577 (19.7%) end = 260904-01: 14: 28Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 439 TPS = 18 SL = 3994 (49.5%) OI = 2443 (19.5%) end = 260904-01: 14: 33Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 450 TPS = 18 SL = 4053 (50.7%) OI = 2427 (30.3%) Oi = 1519 (19%) end = 260904-01: 14: 37Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 451 TPS = 18 SL = 4044 (50.9%) OI = 1595 (19.9%) end = 260904-01: 14: 38 --- End - Sun Sep 26 01:14:38 2004 --- Begin sess = 20 TXN = 10000 oracle_sid = HSBILL Sun SEP 26 01:14:38 2004HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 493 TPS = 16 SL = 4028 (50.4%) OI = 2158 (29.5%) Oi = 1613 (20.2%) end = 260904-01: 24: 55hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 510 TPS = 16 SL = 4077 (51%) ON = 2346 (29.3%) Oi = 157 6 (19.7%) end = 260904-01: 25: 13hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 507 TPS = 16 SL = 4033 (50.4%) ON = 2351 (29.4%) Oi = 1615 (20.2%) end = 260904-01: 25: 13hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 508 TPS = 16 SL = 3980 (49.8%) OI = 2383 (29.8%) end = 260904-01: 25: 14Hsbill.hurray.com.cn TXN (ALL) = 10000 XN (SAM) = 7999 T (SAM) = 505 TPS = 16 SL = 3998 (50%) ON = 2405 (30.1%) Oi = 1596 (20%) end =
260904-01: 25: 14HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 507 TPS = 16 SL = 4048 (50.6%) ON = 2401 (30%) OI = 1550 (19.4%) end = 260904-01: 25: 15HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (sam) = 7999 T (SAM) = 511 TPS = 16 SL = 3998 (50%) ON = 2343 (29.3%) Oi = 1658 (20.7%) end = 260904-01: 25: 17hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 509 TPS = 16 SL = 4001 (50%) ON = 2360 (29.5%) Oi = 1638 (20.5%) end = 260904-01: 25: 17hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 513 TPS = 16 SL = 4048 (50.6%) OI = 1542 (19.3%) end = 260904-01: 25: 19HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 516 TPS = 16 SL = 3969 (49.6%) ON = 2400 (30%) Oi = 1630 (20.4%) end = 260904-01: 25: 21hsbill.hurray.com.cn TXN All) = 10000 xn (SAM) = 7999 T (SAM) = 519 TPS = 15 SL = 3960 (49.5%) ON = 2396 (30%) Oi = 1643 (20.5%) end = 260904-01: 25: 22Hsbill. Hurray.com.cn TXN (AL) = 10000 XN (SAM) = 7999 T (SAM) = 529 TPS = 15 SL = 4032 (50.4%) ON = 2377 (29.7%) Oi = 1590 (19.9%) end = 260904 -01: 25: 26HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 535 TPS = 15 SL = 4080 (51% ON = 2357 (29.5%) Oi = 1562 (19.5%) end = 260904-01: 25: 27HSBILL.HURRAY.com.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 526 TPS = 15 SL = 4080 (51%) OI = 2326 (29.1%) Oi = 1593 (19.9%) end = 260904-01: 25: 27HSBILL.HURRAY.com.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 530 TPS = 15 SL = 4019 (50.2%) ON = 2400 (30%) Oi = 1580 (19.8%) end = 260904-01: 25: 28HSBILL.HURRAY.com.cn TXN (all) = 10000 XN (SAM) = 7999 T (SAM) = 523 TPS = 15 SL = 3945 (49.3%) ON =
2477 (31%) Oi = 1577 (19.7%) end = 260904-01: 25: 28Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 532 TPS = 15 SL = 4058 (50.7%) OI = 2382 (29.5%) end = 260904-01: 25: 30Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 534 TPS = 15 SL = 4029 (50.5%) OI = 2607 (20.1%) end = 260904-01: 25: 30hsbill.hurray.com.cn TXN (AL) = 10000 xn (SAM ) = 7999 t (sam) = 547 TPS = 15 SL = 4027 (50.3%) ON = 2342 (29.3%) Oi = 1630 (20.4%) end = 260904-01: 25: 34Hsbill.hurray.com.cn TXN All) = 10000 xn (SAM) = 7999 T (SAM) = 563 TPS = 14 SL = 4077 (51%) ON = 2344 (29.7%) Oi = 1578 (19.7%) end = 260904-01: 25: 36- --end - Sun Sep 26 01:25:36 2004 --- Begin sess = 25 TXN = 10000 oracle_sid = HSBILL Sun SEP 26 01:25:36 2004Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 t (sam) = 626 TPS = 13 SL = 4011 (50.1%) ON = 2422 (30.6%) Oi = 1566 (19.6%) end = 260904-01: 38: 37HSBILL.HURRAY.com.cn TXN All) = 10000 xn (SAM) = 7999 T (SAM) = 621 TPS = 13 SL = 3964 (49.6%) ON = 2415 (30.2%) Oi = 1620 (20.3%) end = 260904-01: 38: 39Hsbill. Hurray.com.cn TXN (ALL) = 10000 XN (SAM) = 7999 T (SAM) = 631 TPS = 13 SL = 4035 (50.4%) OI = 2401 (30%) end = 260904-01: 38: 39HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (SAM) = 630 TPS = 13 SL = 4014 (50.4%) OI = 1553 (19.4%) end = 260904-01: 38: 44Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 t (sam) = 631 TPS = 13 SL = 4082 (51%) ON = 2343 (29.3%) OI = 1574 (19.7%) end = 260904-01: 38: 44Hsbill.hurray.com.cn TXN All) = 10000 xn (sam) = 7999 T (SAM) = 636 TPS = 13 SL = 3961 (49.5%) ON =
2407 (30.1%) Oi = 1631 (20.4%) end = 260904-01: 38: 47HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 638 TPS = 13 SL = 4048 (50.6%) OI = 2352 (29.4%) Oi = 1599 (20%) end = 260904-01: 38: 50Hsbill.hurray.com.cn TXN (ALL) = 10000 XN (SAM) = 7999 T (SAM) = 636 TPS = 13 SL = 3967 (49.6%) OI = 2414 (30.2%) End = 1618 (20.2%) end = 260904-01: 38: 51Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 t (sam) = 632 TPS = 13 SL = 3970 (49.6%) ON = 2405 (30.1%) Oi = 1624 (20.3%) end = 260904-01: 38: 51Hsbill.hurray.com.cn TXN All) = 10000 xn (SAM) = 7999 T (SAM) = 637 TPS = 13 SL = 3972 (49.7%) ON = 2398 (30%) OI = 1629 (20.4%) end = 260904-01: 38: 51Hsbill. Hurray.com.cn TXN (AL) = 10000 xn (SAM) = 7999 T (SAM) = 637 TPS = 13 SL = 4028 (50.4%) ON = 2406 (30.1%) Oi = 1565 (19.6%) end = 260904 -01: 38: 52HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 634 TPS = 13 SL = 4015 (50.2%) ON = 2383 (29.8%) oi = 1601 (20%) end = 260904-01: 38: 52HSBILL.HURRAY.COM.CN TXN (AL) = 10000 xn (SAM) = 7999 T (SAM) = 638 TPS = 13 SL = 3983 (49.8%) ON = 2502 (31.3%) Oi = 1514 (18.9%) end = 260904-01: 38: 53HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 641 TPS = 12 SL = 3947 (49.3%) OI = 1573 (19.7%) end = 260904-01: 38: 54HSBILL.HURRAY.com.cn TXN (ALL) ) = 10000 xn (sam) = 7999 t (sam) = 647 TPS = 12 SL = 3956 (49.5%) ON = 2426 (30.3%) Oi = 1617 (20.2%) end = 260904-01: 38: 54HSBILL.HURRAY .Com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 636 TPS = 13 SL = 3958 (49.5%) ON = 2481 (31%) Oi = 1560 (19.5%) end = 260904- 01: 38: 54HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) =
644 TPS = 12 SL = 3918 (49%) OI = 2478 (31%) Oi = 1603 (20%) end = 260904-01: 38: 56Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 646 TPS = 12 SL = 4027 (50.9%) OI = 1501 (18.8%) end = 260904-01: 38: 57HSBILL.HURRAY.com.cn TXN (ALL) ) = 10000 xn (sam) = 7999 t (sam) = 644 TPS = 12 SL = 4026 (50.3%) ON = 2426 (30.3%) Oi = 1547 (19.3%) end = 260904-01: 38: 57HSBILL.HURRAY .Com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 645 TPS = 12 SL = 4031 (50.4%) ON = 2359 (29.5%) Oi = 1609 (20.1%) end = 260904- 01: 38: 58HSBILL.HURRAY.com.cn TXN (AL) = 10000 xn (SAM) = 7999 T (SAM) = 647 TPS = 12 SL = 4054 (50.7%) ON = 2330 (29.1%) Oi = 1615 ( 20.2%) end = 260904-01: 38: 58HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 651 TPS = 12 SL = 3960 (49.5%) ON = 2405 ( 30.1%) Oi = 1634 (20.4%) end = 260904-01: 38: 59HSBILL.HURRAY.com.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 660 TPS = 12 SL = 4027 ( 50.3%) on = 2381 (29.8%) Oi = 1591 (19.9%) end = 260904-01: 39: 00hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 t (sam) = 665 TPS = 12 Sl = 3942 (49.3%) ON = 2452 (30.7%) Oi = 1605 (20.1%) end = 260904-01: 39: 01Hsbill.hurray. COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 717 TPS = 11 SL = 4019 (50.2%) ON = 2344 (29.3%) Oi = 1636 (20.5%) end = 260904-01 : 39: 26 --- End - Sun Sep 26 01:39:26 2004 --- Begin sess = 30 TXN = 10000 oracle_sid = HSBILL Sun Sep 26 01:48:31 2004HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 739 TPS = 11 SL = 3994 (49.9%) ON = 2414 (30.2%) Oi = 1591 (19.9%) end = 260904-02: 04: 02Hsbill.hurray. Com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 741 TPS =
11 SL = 3951 (49.4%) ON = 2423 (30.3%) Oi = 1625 (20.3%) end = 260904-02: 04: 02Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 T (SAM) = 745 TPS = 11 SL = 4043 (50.5%) ON = 2357 (29.5%) Oi = 1599 (20%) end = 260904-02: 04: 05HSBILL.HURRAY.com.cn TXN (all) = 10000 XN (SAM) = 7999 T (SAM) = 751 TPS = 11 SL = 3993 (49.9%) OI = 2449 (30.6%) OI = 1557 (19.5%) end = 260904-02: 04: 07Hsbill.hurray.com. CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 749 TPS = 11 SL = 4018 (50.2%) OI = 1576 (19.7%) end = 260904-02: 04 : 10HSBILL.HURRAY.com.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 750 TPS = 11 SL = 3994 (49.9%) OI = 1611 (20.1%) End = 260904-02: 04: 11HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 751 TPS = 11 SL = 4066 (50.8%) ON = 2369 (29.6%) Oi = 1564 (19.6%) end = 260904-02: 04: 11hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 752 TPS = 11 SL = 3973 (49.7%) ON = 2374 (29.7%) Oi = 1652 (20.7%) end = 260904-02: 04: 12hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 759 TPS = 11 SL = 3887 (48.6%) ON = 2515 (31.4%) Oi = 1597 (20%) end = 260904-02: 04: 13Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 754 TPS = 11 SL = 3974 (49.7%) OI = 1586 (19.8%) end = 260904-02: 04: 13HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 XN (SAM) = 7999 T (SAM) = 755 TPS = 11 SL = 4000 (50%) ON = 2336 (29.2%) Oi = 1663 (20.8%) end = 260904-02: 04: 13HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 757 TPS = 11 SL = 3931 (49.1%) ON = 2442 (30.5%) OI = 1626 (20.3%) end = 260904-02: 04: 14Hsbill.hurray.com.cn TXN (all) =
10000 XN (SAM) = 7999 T (SAM) = 758 TPS = 11 SL = 3989 (49.9%) ON = 2401 (30%) Oi = 1609 (20.1%) end = 260904-02: 04: 14HSBILL.HURRAY.COM .CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 757 TPS = 11 SL = 3974 (49.7%) ON = 2403 (30%) Oi = 1622 (20.3%) end = 260904-02: 04: 15HSBILL.HURRAY.COM.CN TXN (AL) = 10000 xn (SAM) = 7999 T (SAM) = 760 TPS = 11 SL = 4049 (50.6%) ON = 2375 (29.7%) Oi = 1575 (19.7% ) end = 260904-02: 04: 15HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 761 TPS = 11 SL = 3870 (48.4%) ON = 2416 (30.2% ) Oi = 1713 (21.4%) end = 260904-02: 04: 17HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 758 TPS = 11 SL = 4036 (50.5% OI = 2368 (29.6%) Oi = 1595 (19.9%) end = 260904-02: 04: 17HSBILL.HURRAY.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 761 TPS = 11 SL = 3966 (49.6%) OI = 2445 (30.6%) End = 1588 (19.9%) end = 260904-02: 04: 18Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 761 TPS = 11 SL = 3969 (49.6%) ON = 2413 (30.2%) Oi = 1617 (20.2%) end = 260904-02: 04: 18hsbill.hurray.com.cn TXN (all) = 10000 XN (SAM) = 7999 T (SAM) = 761 TPS = 11 SL = 3999 (50%) OI = 1583 (19.8%) end = 260 904-02: 04: 19HSBILL.HURRAY.COM.CN TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 755 TPS = 11 SL = 4060 (50.6%) ON = 2366 (29.6%) OI = 1573 (19.7%) end = 260904-02: 04: 20hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 774 TPS = 10 SL = 4041 (50.5%) ON = 2367 (29.6%) Oi = 1591 (19.9%) end = 260904-02: 04: 21hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 763 TPS = 10 SL = 4087 (51.1%) ON = 2343 (29.3%) oi = 1569 (19.6%) end =
260904-02: 04: 22Hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 769 TPS = 10 SL = 4021 (50.3%) ON = 2407 (30.1%) OI = 1571 (19.6%) end = 260904-02: 04: 23hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 773 TPS = 10 SL = 4019 (50.2%) ON = 2413 (30.2%) Oi = 1567 (19.6%) end = 260904-02: 04: 23hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 763 TPS = 10 SL = 4004 (50.1%) OI = 2352 (29.4%) end = 1643 (20.5%) end = 260904-02: 04: 24hsbill.hurray.com.cn TXN (ALL) = 10000 xn (sam) = 7999 t (sam) = 770 TPS = 10 Sl = 4063 (50.8%) OI = 1582 (19.8%) end = 260904-02: 04: 24hsbill.hurray.com.cn TXN (ALL) = 10000 xn (SAM ) = 7999 T (SAM) = 779 TPS = 10 SL = 4019 (50.8%) OI = 1581 (19.8%) end = 260904-02: 04: 24hsbill.hurray.com.cn TXN All) = 10000 xn (SAM) = 7999 T (SAM) = 784 TPS = 10 SL = 4032 (50.4%) ON = 2374 (29.7%) Oi = 1593 (19.9%) end = 260904-02: 04: 26Hsbill. Hurray.com.cn TXN (ALL) = 10000 xn (SAM) = 7999 T (SAM) = 809 TPS = 10 SL = 3962 (49.7%) OI = 1579 (19.7%) end = 260904 -02: 04: 28 --- End - Sun Sep 26 02:04:28 20043. Using script formatted output
$ Orabm_tps.sh ./solaris/bm.hsbill.logORACLE_SID=hsbill sess = 1 tps = 90ORACLE_SID = hsbill sess = 2 tps = 160ORACLE_SID = hsbill sess = 6 tps = 245ORACLE_SID = hsbill sess = 10 tps = 276ORACLE_SID = hsbill sess = 15 TPS = 289Oracle_sid = HSBILL SESS = 20 TPS = 309Oracle_sid = HSBILL sess = 25 TPS = 313 OCLE_SID = HSBILL sess = 30 TPS = 321
Here we can see that the CPU performance TPS value of this server should be around 310.
