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
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.
0 Comments