...
SwingBench is a free load generator and benchmark utility designed by Dominic Giles to stress test an Oracle database (10g,11g,12c). Rep Attack uses SwingBench to generate test data and provide a transaction load for the Dbvisit Replicate.
REPOE Schema
Table Size and Row Count
The data in the tables has been randomly generated by the SwingBench using the oewizard command with the following arguments.
| No Format |
|---|
oewizard -cl -create -cs //source-int/orcl -scale 0.5 -u repoe -p repoe -ts users -tc 7 -v -dba system -dbap manager |
The data in the tables has been automatically generated so it may look a little strange.
| Table Name | Initial Row Count | Initial Size (Mb) |
|---|---|---|
| CUSTOMERS | 500,000 | 72 |
| ADDRESSES | 750,000 | 72 |
| CARD_DETAILS | 750,000 | 40 |
| ORDERS | 714,895 | 80 |
| ORDER_ITEMS | 6,674,106 | 144 |
| Info |
|---|
Sounds funny, but the Rep Attack machines don't come with Dbvisit Replicate installed! The first exercise after you have the source and target machines running is to install Replicate. |