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).
...
1. Logon as oracle (password is oracle).
| No Format |
|---|
su - oracle |
2. Run the swingbench command to create and load the tables.
The command is:
| No Format |
|---|
/u01/oracle/swingbench/bin/oewizard -cl -create -cs //source-int/orclpdb1 -scale 1 -u oe -p oe -ts users -tc 7 -v -dba system -dbap oracle SwingBench Wizard Author : |
| Note |
|---|
The "scale" factor is used to indicate the size of the data set that is created. If a smaller dataset is required, then decrease the scale. For example: "-scale 0.5" |
The output is:
| No Format |
|---|
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/orclpdb1 Connected Starting run Starting script ../sql/soedgdrop2.sql Script completed in 0 hour(s) 0 minute(s) 1 second(s) 829755 millisecond(s) Starting script ../sql/soedgcreatetables2.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 646549 millisecond(s) Starting script ../sql/soedgviews.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 4762 millisecond(s) Starting script ../sql/soedgsqlset.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 71184 millisecond(s) Inserting data into table ADDRESSES_1 750000 Inserting data into table CUSTOMERSADDRESSES_1 Inserting data into table ORDER_ITEMSCUSTOMERS_1 Inserting data into table ORDERS_1 ORDER_ITEMS_714895 Inserting data into table CARD_DETAILS_1 CUSTOMERS_500000 Inserting data into table PRODUCT_INFORMATIONORDERS_714895 Inserting data into table LOGONORDERS_1 Inserting data into table INVENTORIESORDER_ITEMS_1 Completed processing table PRODUCTADDRESSES_INFORMATION750000 in 0:00:0102:31 Completed processing table INVENTORIESADDRESSES_1 in 0:02:2736 Inserting data into table PRODUCT_DESCRIPTIONSCARD_DETAILS_750000 Completed processing table PRODUCTCUSTOMERS_DESCRIPTIONS500000 in 0:00:0403:48 Inserting data into table WAREHOUSES CARD_DETAILS_1 Completed processing table WAREHOUSESCARD_DETAILS_750000 in 0:0001:0015 Inserting data into table LOGON_1191492 Completed processing table LOGON_1 in 0:09:28 Completed processing table CARD_DETAILSCUSTOMERS_1 in 0:10:1704:04 Inserting Completeddata processinginto table ADDRESSESLOGON_1 in 0:12:00 Completed processing table CUSTOMERSLOGON_11191492 in 0:1501:2501 Inserting data Completed processinginto table ORDERSPRODUCT_1INFORMATION in 0:21:39 Inserting Connectiondata cacheinto closedtable INVENTORIES Completed processing table PRODUCT_INFORMATION in 0:00:00 Starting script ../sql/soedganalyzeschema2.sql Completed processing table CARD_DETAILS_1 in 0:01:14 Script completed in 0 hour(s) 0 minute(s) 0 second(s) 353 millisecond(s)Inserting data into table PRODUCT_DESCRIPTIONS Starting script ../sql/soedgconstraints2.sql Completed processing table PRODUCT_DESCRIPTIONS in 0:00:01 Script completed in 0 hour(s) 0 minute(s) 36 second(s) 589 millisecond(s) Starting script ../sql/soedgindexes2.sql Inserting data into table WAREHOUSES Script completed in 0 hour(s) 1 minute(s) 10 second(s) 161 millisecond(s)Completed processing table WAREHOUSES in 0:00:00 Starting script ../sql/soedgsequences2.sql Completed processing Script completedtable LOGON_1 in 0 hour(s) 0 minute(s) 2 second(s) 645 millisecond(s):01:00 Starting script ../sql/soedgpackage2_header.sql Completed processing table INVENTORIES in 0:00:34 Script completed in 0 hour(s) 0 minute(s) 0 second(s) 428 millisecond(s) Starting script ../sql/soedgpackage2_body.sql Completed processing table ORDERS_714895 in 0:07:28 Script completed in 0 hour(s) 0 minute(s) 0 second(s) 608 millisecond(s) Starting script ../sql/soedgsetupmetadata.sql Completed processing Scripttable completedORDERS_1 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 |
|---|
:07:29
Completed processing table ORDER_ITEMS_714895 in 0:07:31
Connection cache closed
Starting script ../sql/soedganalyzeschema2.sql
Script completed in 0 hour(s) 0 minute(s) 0 second(s) 346 millisecond(s)
Starting script ../sql/soedgconstraints2.sql
Script completed in 0 hour(s) 0 minute(s) 51 second(s) 162 millisecond(s)
Starting script ../sql/soedgindexes2.sql
Script completed in 0 hour(s) 1 minute(s) 19 second(s) 941 millisecond(s)
Starting script ../sql/soedgsequences2.sql
Script completed in 0 hour(s) 0 minute(s) 3 second(s) 61 millisecond(s)
Starting script ../sql/soedgpackage2_header.sql
Script completed in 0 hour(s) 0 minute(s) 0 second(s) 724 millisecond(s)
Starting script ../sql/soedgpackage2_body.sql
Script completed in 0 hour(s) 0 minute(s) 0 second(s) 558 millisecond(s)
Starting script ../sql/soedgsetupmetadata.sql
Script completed in 0 hour(s) 0 minute(s) 2 second(s) 262 millisecond(s) |
| Note |
|---|
The username is: oe |
3. At the end there is a summary of the tables that have been loaded.
| No Format |
|---|
============================================ | Datagenerator Run Stats | ====================================================== | Connection Time 0:00:00.017 Data Generation Time 0:07:32.026 DDL Creation Time Datagenerator Run Stats | ============================================ Connection Time 0:02:20.771 Total Run Time 0:0009:00.005 Data Generation Time52.828 Rows Inserted per sec 26,782 Data Generated (MB) per sec 0:22:58.270 DDL Creation Time 2.2 Actual Rows Generated 0:02:10.680 Total Run Time 13,006,584 Connecting to : jdbc:oracle:thin:@//source-int/pdb1 0:25:08.959 Rows Inserted per sec Connected 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 |
34. Run Swingbench to test that it is working. This is using the command line version of Swingbench called Charbench.
The command is:
| No Format |
|---|
$ /homeu01/oracle/swingbench/bin/charbench -v users,tps,trans -cs //source-int/orclpdb1 -u oe -p oe -uc 5 -min 101 -max 200 -rt 0:10 -a |
The output is:
| No Format |
|---|
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 1 minutes, you can stop any time by hitting ctrl-c.