...
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
The Rep Attack machines come pre-loaded with an application schema and test data generated by SwingBench that you will be using to perform the Rep Attack exercises.
The schema is called REPOE and it's based on the Order Entry (OE) example schema that comes with Oracle. It's Entity Relationship diagram is shown below.
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. The data in the tables has been automatically generated so it may look a little strange.
| 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 |
| PRODUCT_INFORMATION | 1,000 | 0.25 |
| PRODUCT_DESCRIPTIONS | 1,000 | 0.32 |
| INVENTORIES | 900,131 | 176 |
| WAREHOUSES | 1,000 | 0.06 |
| LOGON | 1,191,492 | 32 |
| ORDERENTRY_METADATA | 4 | 0.06 |
...
A couple of helper scripts have been included with the virtual machines in the $HOME/replicate directory of the oracle user to assist you with running the SwingBench transaction generator and determining the records counts between the source and target schemas.
...
It also computes the total of all orders in the ORDERS table. This script is useful as a high level audit of the status of the replication.
For example:, this is the output of the script at the start of Rep Attack. The source schema (REPOE) has been created with the tables and loaded with the initial data, while the target schema (also called REPOE) has been created but contains no tables.
| No Format |
|---|
[oracle@source replicate]$ ./record_count.bash TABLE_NAME SOURCE DB TARGET DB ------------------------------ ----------- ----------- ADDRESSES 750000 *No Table* CARD_DETAILS 750000 *No Table* CUSTOMERS 500000 *No Table* INVENTORIES 900131 *No Table* LOGON 1191492 *No Table* ORDERENTRY_METADATA 4 *No Table* ORDERS 714895 *No Table* ORDER_ITEMS 2143687 *No Table* PRODUCT_DESCRIPTIONS 1000 *No Table* PRODUCT_INFORMATION 1000 *No Table* WAREHOUSES 1000 *No Table* 11 rows selected. Sum of orders SOURCE DB TARGET DB ------------- ------------------ ------------------ ORDERS $3,572,944,731.00 $.00 [oracle@source replicate]$ |
...