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).
2. Logon as oracle.
| No Format |
|---|
su - oracle |
3. 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/pdb1 -scale 1 -u oe -p oe -ts users -tc 7 -v -dba system -dbap oracle |
...
| Note |
|---|
The username is: oe |
24. 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 0:02:20.771 Total Run Time 0:09:52.828 Rows Inserted per sec 26,782 Data Generated (MB) per sec 2.2 Actual Rows Generated 13,006,584 Connecting to : jdbc:oracle:thin:@//source-int/pdb1 Connected 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 |
35. Run Swingbench to test that it is working. This is using the command line version of Swingbench called Charbench.
...