Operating System
The 64 bit version of the minimal install of Centos 6.5 is used for the Rep Attack operating system. This is a minimal install with no X Windows software or graphical user interface. The ISO image used for the install can be found by following the links on the Centos isoredirect page.
Oracle Express Edition
Oracle Express Edition has already been installed…
It can be downloaded from the Oracle Database Express Edition 11g Release 2 downloads page. It requires you to sign up for a (free) Oracle Account if you don't already have one.
SwingBench
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.
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 |
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.
Add Comment