Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Swingbench can now be started to simulate an order-entry system and test the replication.

1. Start a new ssh session to the source server (dbv01) and logon as oracle

ssh oracle@source-int

2. Start charbench which is the character based version of swingbench

cd ~oracle/swingbench/bin
./charbench -cs //source-int/orcl -u oe -p oe -uc 10 -min 10 -max 200 -rt 0:10 -a -v

The output will be similar to the following and will run for 10 minutes. A total number of 10 users will be simulated. 

Author  :	 Dominic Giles
Version :	 2.5.0.909
Results will be written to results.xml.
Time		Users	TPM	TPS
8:39:02 PM	0	0	0
8:39:03 PM	0	0	0
8:39:04 PM	0	0	0
8:39:05 PM	2	0	0
8:39:06 PM	10	10	10
8:39:07 PM	10	23	13

2. Switch to the session where the Dbvisit Replicate console is running and the replication can be seen to be working

- Dbvisit Replicate 2.6.00.3735(MAX edition) - Evaluation License expires in 30 days
MINE IS running. Currently at plog 715 and SCN 14587518 (12/28/2013 20:44:38).
APPLY IS running. Currently at plog 715 and SCN 14587446 (12/28/2013 20:44:36).
Progress of replication dbvrep_orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
OE.CUSTOMERS:                  98%  Mine:372/372         Unrecov:0/0         Applied:365/365     Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.ADDRESSES:                  98%  Mine:372/372         Unrecov:0/0         Applied:365/365     Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.CARD_DETAILS:               98%  Mine:331/331         Unrecov:0/0         Applied:327/327     Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.ORDER_ITEMS:                97%  Mine:2636/2636       Unrecov:0/0         Applied:2582/2582   Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.ORDERS:                     98%  Mine:2140/2140       Unrecov:0/0         Applied:2098/2098   Conflicts:0/0       Last:28/12/2013 20:44:39/OK
OE.INVENTORIES:                97%  Mine:2577/2577       Unrecov:0/0         Applied:2525/2525   Conflicts:0/0       Last:28/12/2013 20:44:38/OK
OE.LOGON:                      98%  Mine:2605/2605       Unrecov:0/0         Applied:2554/2554   Conflicts:0/0       Last:28/12/2013 20:44:39/OK
--------------------------------------------------------------------------------------------------------------------------------------------
7 tables listed.

3. Optional. Swingbench is highly configurable. The load on the system can be easily increased. In this example, the number of users is set to 40 and the min and max delay is shortened. As a result the TPS peaks at over 400 transactions per second

[oracle@source bin]$ ./charbench -cs //source-int/orcl -u oe -p oe -uc 40 -min 5 -max 15 -rt 0:10 -a -v users,tpm,tps
Author  :	 Dominic Giles
Version :	 2.5.0.909
Results will be written to results.xml.
Time		Users	TPM	TPS
20:53:05	[0/40]	0	0
20:53:06	[0/40]	0	0
20:53:07	[0/40]	0	0
20:53:08	[0/40]	0	0
20:53:10	[31/40]	0	0
20:53:13	[40/40]	440	440
20:53:14	[40/40]	478	38
20:53:18	[40/40]	913	435
20:53:19	[40/40]	967	54
20:53:22	[40/40]	1410	443
20:53:23	[40/40]	1446	36
20:53:25	[40/40]	1745	299
20:53:26	[40/40]	1885	140

 

 

  • No labels