Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Doc for oewizard #21

Open
albertyckwok opened this issue Apr 11, 2022 · 0 comments
Open

Doc for oewizard #21

albertyckwok opened this issue Apr 11, 2022 · 0 comments

Comments

@albertyckwok
Copy link

Hi, I am wondering if there is documentation with details of parameters for oewizard. I frequently need to generate a given size of data for benchmark activities. The command ./oewizard --help return stating that scale parameter is a mulitiplier for default config. I would like to know what number I should give as scale parameter to generate say 1TB of data (tablespace). I try a scale of 320 and get around 0.7TB of tablespace. The following is what I did and get:

apptool7:bin$ nohup ./oewizard -cs $nodeName-scan.$domName:1521/${myInit}pdb$myDBnum.$domName -dt thin -dba "sys as sysdba" -dbap $pp$myDBnum -ts SOE -u soe -p ${pp}$myDBnum -create -nopart -cl -v -scale 320 & sleep 3; tail -f ~/nohup.out
SwingBench Wizard
Author  :	 Dominic Giles
Version :	 2.6.0.1137

Running in Lights Out Mode using config file : ../wizardconfigs/oewizard.xml
Connecting to : jdbc:oracle:thin:@ecc9c4-scan.us.osc.oracle.com:1521/a1pdb0.us.osc.oracle.com
Connected                                                                  
Running script ../sql/soedgcreatetablespace.sql                            
Script completed in 0 hour(s) 0 minute(s) 17 second(s) 297 millisecond(s)  
::::::::::::skip::::::::::::::::
Starting script ../sql/soedgpackage2_body.sql                              
Script completed in 0 hour(s) 0 minute(s) 0 second(s) 197 millisecond(s)   
Starting script ../sql/soedgsetupmetadata.sql                              
Script completed in 0 hour(s) 0 minute(s) 7 second(s) 572 millisecond(s)   

============================================
|           Datagenerator Run Stats        |
============================================
Connection Time                        0:00:00.003
Data Generation Time                   3:12:12.359
DDL Creation Time                      0:59:50.425
Total Run Time                         4:12:02.789
Rows Inserted per sec                      415,236
Data Generated (MB) per sec                   33.5
Actual Rows Generated                4,789,574,512
Commits Completed                          239,579
Batch Updates Completed                 23,947,982

Connecting to : jdbc:oracle:thin:@ecc9c4-scan.us.osc.oracle.com:1521/a1pdb0.us.osc.oracle.com
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
apptool7:~$ sqlplus "sys/${pp}$myDBnum@$nodeName-scan.$domName:1521/${myInit}pdb$myDBnum.$domName" as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Apr 11 11:04:24 2022
Version 21.4.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> select tablespace_name, sum(bytes/1024/1024/1024/1024) from dba_data_files group by tablespace_name;

TABLESPACE_NAME 	       SUM(BYTES/1024/1024/1024/1024)
------------------------------ ------------------------------
SYSTEM						   .000572205
UNDOTBS1					   .004478455
SYSAUX						   .000572205
USERS						   .000976563
UNDO_2						   .004478455
SOE						       .71875

6 rows selected.

SQL> Disconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

Thanks very much in advance
Albert

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant