...
...
To install Swingbench 2.5 you need to ensure you have a Java 6/7 JVM available.
Download from https://www.java.com/en/download/manual.jsp and follow the instructions. This must be done as root
1. Create the initial Swingbench tables and load them with data. This takes about 25 minutes to run. This is using the command line version of Swingbench (-cl).
| No Format |
|---|
/home/oracle/swingbench/bin/oewizard -cl -create -cs //source-int/orcl -scale 1 -u oe -p oe -ts users -tc 7 -v -dba system -dbap oracle SwingBench Wizard Author : Dominic Giles Version : 2.5.0.909932 Running in Lights Out Mode using config file : oewizard.xml Connecting to : jdbc:oracle:thin:@//source-int/orcl Connected Starting run Starting script ../sql/soedgdrop2.sql Script completed in 0 hour(s) 0 minute(s) 1 second(s) 829 millisecond(s) Starting script ../sql/soedgcreatetables2.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 646 millisecond(s) Starting script ../sql/soedgviews.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 47 millisecond(s) Starting script ../sql/soedgsqlset.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 71 millisecond(s) Inserting data into table ADDRESSES_1 Inserting data into table CUSTOMERS_1 Inserting data into table ORDER_ITEMS_1 Inserting data into table ORDERS_1 Inserting data into table CARD_DETAILS_1 Inserting data into table PRODUCT_INFORMATION Inserting data into table LOGON_1 Inserting data into table INVENTORIES Completed processing table PRODUCT_INFORMATION in 0:00:01 Completed processing table INVENTORIES in 0:02:27 Inserting data into table PRODUCT_DESCRIPTIONS Completed processing table PRODUCT_DESCRIPTIONS in 0:00:04 Inserting data into table WAREHOUSES Completed processing table WAREHOUSES in 0:00:00 Completed processing table LOGON_1 in 0:09:28 Completed processing table CARD_DETAILS_1 in 0:10:17 Completed processing table ADDRESSES_1 in 0:12:00 Completed processing table CUSTOMERS_1 in 0:15:25 Completed processing table ORDERS_1 in 0:21:39 Connection cache closed Starting script ../sql/soedganalyzeschema2.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 353 millisecond(s) Starting script ../sql/soedgconstraints2.sql Script completed in 0 hour(s) 0 minute(s) 36 second(s) 589 millisecond(s) Starting script ../sql/soedgindexes2.sql Script completed in 0 hour(s) 1 minute(s) 10 second(s) 161 millisecond(s) Starting script ../sql/soedgsequences2.sql Script completed in 0 hour(s) 0 minute(s) 2 second(s) 645 millisecond(s) Starting script ../sql/soedgpackage2_header.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 428 millisecond(s) Starting script ../sql/soedgpackage2_body.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 608 millisecond(s) Starting script ../sql/soedgsetupmetadata.sql Script completed in 0 hour(s) 0 minute(s) 4 second(s) 500 millisecond(s) |
| Note |
|---|
The username is: oe |
...
2. At the end there is a summary of the tables that have been loaded.
| No Format |
|---|
============================================ | Datagenerator Run Stats | ============================================ Connection Time 0:00:00.005 Data Generation Time 0:22:58.270 DDL Creation Time 0:02:10.680 Total Run Time 0:25:08.959 Rows Inserted per sec 8,784 Data Generated (MB) per sec 0.7 Actual Rows Generated 13,004,927 Post Creation Validation Report =============================== The schema appears to have been created successfully. Valid Objects ============= Valid Tables : 'ORDERS','ORDER_ITEMS','CUSTOMERS','WAREHOUSES','ORDERENTRY_METADATA','INVENTORIES','PRODUCT_INFORMATION','PRODUCT_DESCRIPTIONS','ADDRESSES','CARD_DETAILS' Valid Indexes : 'PRD_DESC_PK','PROD_NAME_IX','PRODUCT_INFORMATION_PK','PROD_SUPPLIER_IX','PROD_CATEGORY_IX','INVENTORY_PK','INV_PRODUCT_IX','INV_WAREHOUSE_IX','ORDER_PK','ORD_SALES_REP_IX','ORD_CUSTOMER_IX','ORD_ORDER_DATE_IX','ORD_WAREHOUSE_IX','ORDER_ITEMS_PK','ITEM_ORDER_IX','ITEM_PRODUCT_IX','WAREHOUSES_PK','WHS_LOCATION_IX','CUSTOMERS_PK','CUST_EMAIL_IX','CUST_ACCOUNT_MANAGER_IX','CUST_FUNC_LOWER_NAME_IX','ADDRESS_PK','ADDRESS_CUST_IX','CARD_DETAILS_PK','CARDDETAILS_CUST_IX' Valid Views : 'PRODUCTS','PRODUCT_PRICES' Valid Sequences : 'CUSTOMER_SEQ','ORDERS_SEQ','ADDRESS_SEQ','LOGON_SEQ','CARD_DETAILS_SEQ' Valid Code : 'ORDERENTRY' Schema Created |
...
3. Run Swingbench to test that it is working. This is using the command line version of Swingbench called Charbench.
| No Format |
|---|
$ /home/oracle/swingbench/bin/charbench -v users,tps,trans -cs //source-int/orcl -u oe -p oe -uc 5 -min 10 -max 200 -rt 0:10 -a Author : Dominic Giles Version : 2.5.0.909932 Results will be written to results.xml. Time Users TPS NCR UCD BP OP PO BO SQ WQ WA 17:09:28 [0/5] 0 0 0 0 0 0 0 0 0 0 17:09:29 [5/5] 0 0 0 0 0 0 0 0 0 0 17:09:30 [5/5] 0 0 0 0 0 0 0 0 0 0 17:09:31 [5/5] 5 1 0 3 1 0 0 0 0 0 17:09:32 [5/5] 9 4 0 7 3 0 0 0 0 0 17:09:33 [5/5] 5 5 0 10 4 0 0 0 0 0 17:09:34 [5/5] 7 5 0 13 8 0 0 0 0 0 17:09:35 [5/5] 9 6 2 18 9 0 0 0 0 0 17:09:36 [5/5] 5 6 2 20 12 0 0 0 0 0 17:09:37 [5/5] 3 6 2 21 14 0 0 0 0 0 17:09:38 [5/5] 9 7 3 25 16 1 0 0 0 0 17:09:39 [5/5] 8 9 3 27 19 1 1 0 0 0 17:09:40 [5/5] 8 9 4 31 21 2 1 0 0 0 17:09:41 [5/5] 5 9 4 35 22 2 1 0 0 0 17:09:42 [5/5] 6 10 4 37 25 2 1 0 0 0 17:09:43 [5/5] 10 12 4 41 28 3 1 0 0 0 17:09:44 [5/5] 5 13 4 43 29 3 2 0 0 0 |
This will run for about 10 minutes, you can stop any time by hitting ctrl-c.