Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

No Format
ssh oracle@source-int

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

No Format
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

No Format
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

...

When we successfully installed DBVisit Replicate product on our RepAttack environment, we should test, how the replication works itself. 

This chapter brings some basic examples, that should demonstrate the user how the logical replication works, how are the replicated DMLs transformed, how to use and monitor replicate and how to setup some basic features of replicate such as filtering rows and excluding columns.

Pre-requisites

Please ensure the following pre-requisites have been completed

  1. Download and install Replicate
  2. One-Way Logical Replication Setup

Follow the step by step guide in the Child Pages below. 

Child pages (Children Display)