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.909 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) |
...