Swingbench is a free load generator (and benchmarks) designed by Dominic Giles to stress test an Oracle database (10g,11g,12c).
In this example, we will use charbench which is the command line interface to Swingbench.
1. Download Swingbench
| No Format |
|---|
su - oracle
mkdir software
cd software
wget http://dominicgiles.com/swingbench/swingbench25909.zip |
2. Unzip the software
...
Swingbench is a free load generator (and benchmarks) designed by Dominic Giles to stress test an Oracle database (10g,11g,12c).
In this example, we will use charbench which is the command line interface to Swingbench.
1. Download Swingbench.
| No Format |
|---|
su - oracle |
| No Format |
|---|
mkdir software |
| No Format |
|---|
cd software |
| No Format |
|---|
wget http://dominicgiles.com/swingbench/swingbench25932.zip |
| Note | ||
|---|---|---|
If there is no Internet connection and the Swingbench software has been downloaded to the host (laptop), then the following command can be used to copy the software from the host machine to the first VM (dbv01):
This uses port forwarding which was setup when Virtual Box was configured (02 - Set up NAT network in Virtual Box). 192.168.1.197 is the IP address of the host machine (laptop). Use ifconfig or ipconfig to identify what the local IP address is of your host machine. |
2. Unzip the software.
| No Format |
|---|
unzip swingbench25932.zip Archive: swingbench25932.zip creating: swingbench/ inflating: swingbench/.DS_Store creating: swingbench/bin/ inflating: swingbench/bin/bmcompare inflating: swingbench/bin/ccconfig.xml inflating: swingbench/bin/ccwizard inflating: swingbench/bin/ccwizard.xml inflating: swingbench/bin/charbench inflating: swingbench/bin/clusteroverview inflating: swingbench/bin/clusteroverview.xml inflating: swingbench/bin/coordinator creating: swingbench/bin/data/ inflating: swingbench/bin/data/1000mostpopularadjectives.txt inflating: swingbench/bin/data/1000mostpopularwords.txt inflating: swingbench/bin/data/100mostpopularwords.txt inflating: swingbench/bin/data/catalogue.txt inflating: swingbench/bin/data/counties.txt inflating: swingbench/bin/data/countries.txt extracting: swingbench/bin/data/domains.txt inflating: swingbench/bin/data/emails.txt inflating: swingbench/bin/data/lowerfirstnames.txt inflating: swingbench/bin/data/lowerlastnames.txt inflating: swingbench/bin/bmcomparedata/names.txt inflating: swingbench/bin/ccconfigdata/nls.xmltxt inflating: swingbench/bin/ccwizarddata/productids.txt inflating: swingbench/bin/data/ccwizardtitles.xmltxt inflating: swingbench/bin/charbenchdata/towns.txt inflating: swingbench/bin/clusteroverviewminibench inflating: swingbench/bin/clusteroverview.xmloewizard inflating: swingbench/bin/coordinatoroewizard.xml creatinginflating: swingbench/bin/data/shwizard inflating: swingbench/bin/data/1000mostpopularadjectivesshwizard.txtxml inflating: swingbench/bin/data/1000mostpopularwords.txtswingbench inflating: swingbench/bin/data/100mostpopularwords.txtswingconfig.xml inflatingcreating: swingbench/bin/data/catalogue.txtconfigs/ inflating: swingbench/binconfigs/data/countiesccconfig.txtxml inflating: swingbench/binconfigs/data/countries.txtoeconfig.xml extractinginflating: swingbench/binconfigs/data/domainsshconfig.txtxml inflating: swingbench/binconfigs/data/emailsspconfig.txtxml inflating: swingbench/binconfigs/data/lowerfirstnamesstresstest.txtxml inflating: swingbench/binconfigs/data/lowerlastnamesswingconfigv1.txtxml inflating: swingbench/binconfigs/data/names.txtswingconfigv2.xml inflatingcreating: swingbench/bin/data/nls.txtlauncher/ inflating: swingbench/bin/data/productids.txtlauncher/commons-launcher.jar inflating: swingbench/binlauncher/data/titleslauncher.txtproperties inflating: swingbench/binlauncher/data/townslauncher.txtxml inflating: swingbench/bin/minibenchlauncher/LauncherBootstrap.class inflatingcreating: swingbench/binlib/oewizard inflatingcreating: swingbench/bin/oewizard.xmllib/launcher/ inflating: swingbench/bin/shwizardlib/launcher/ant-launcher.jar inflating: swingbench/binlib/shwizardlauncher/ant.xmljar inflating: swingbench/bin/swingbenchlib/launcher/xercesImpl.jar inflating: swingbench/bin/swingconfig.xmllib/launcher/xml-apis.jar creatinginflating: swingbench/configslib/ojdbc6.jar inflating: swingbench/configslib/ccconfigons.xmljar inflating: swingbench/configslib/oeconfigsimplefan.xmljar inflating: swingbench/configslib/shconfigswingbench.xmljar inflating: swingbench/configslib/spconfigucp.xmljar inflatingcreating: swingbench/configslog/stresstest.xml inflating: swingbench/configs/swingconfigv1README.xmltxt inflating: swingbench/configs/swingconfigv2.xml creating: swingbench/launchersource/ inflating: swingbench/launcher/commons-launcher.jarsource/antbuild inflating: swingbench/launchersource/launcherbuild.propertiesxml inflatingcreating: swingbench/source/launchercom/launcher.xml inflatingcreating: swingbench/source/com/launcherdom/LauncherBootstrap.class creating: swingbench/lib/source/com/dom/benchmarking/ creating: swingbench/lib/launcher/source/com/dom/benchmarking/swingbench/ inflating creating: swingbench/lib/launcher/ant-launcher.jar/source/com/dom/benchmarking/swingbench/dsstransactions/ inflating: swingbench/lib/launcher/ant.jar/source/com/dom/benchmarking/swingbench/dsstransactions/PeriodToPeriodComparison.java inflating: swingbench/lib/launcher/xercesImpl.jar/source/com/dom/benchmarking/swingbench/dsstransactions/ProductSalesRollupCube.java inflating: swingbench/lib/launcher/xml-apis.jar/source/com/dom/benchmarking/swingbench/dsstransactions/SalesByCountryForGivenYear.java inflating: swingbench/lib/ojdbc6.jarsource/com/dom/benchmarking/swingbench/dsstransactions/SalesByQuarterCountry.java inflating: swingbench/source/com/dom/benchmarking/swingbench/libdsstransactions/onsSalesCubeByMonth.jarjava inflating: swingbench/source/com/dom/benchmarking/swingbench/libdsstransactions/simplefanSalesHistory.jarjava inflating: swingbench/lib/source/com/dom/benchmarking/swingbench/dsstransactions/SalesMovingAverage.jarjava inflating: swingbench/source/lib/ucp.jar creating: swingbench/log/ inflating: swingbench/README.txtcom/dom/benchmarking/swingbench/dsstransactions/SalesRollupByMonth.java creatinginflating: swingbench/source/ inflating: com/dom/benchmarking/swingbench/sourcedsstransactions/antbuildSimpleLookUp.java inflating: swingbench/source/build.xml/com/dom/benchmarking/swingbench/dsstransactions/TopSalesWithinQuarter.java creating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/ creatinginflating: swingbench/source/com/dom/ creating: benchmarking/swingbench/source/com/dom/benchmarking/plsqltransactions/BrowseAndUpdateOrders.java creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/BrowseProducts.java creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/NewCustomerProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/PeriodToPeriodComparisonNewCustomerProcessV2.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/ProductSalesRollupCubeNewOrderProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/SalesByCountryForGivenYearOrderEntryProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/SalesByQuarterCountryProcessOrders.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/SalesCubeByMonthSalesRepsOrdersQuery.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/SalesHistoryUpdateCustomerDetailsV2.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/SalesMovingAverageWarehouseActivityQuery.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsplsqltransactions/SalesRollupByMonthWarehouseOrdersQuery.java inflatingcreating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/SimpleLookUp.java inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/TopSalesWithinQuarternewStoredProcedure.java creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstoredprocedures/StoredProcedure1.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstoredprocedures/BrowseAndUpdateOrdersStoredProcedure2.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstoredprocedures/BrowseProductsStoredProcedure3.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstoredprocedures/NewCustomerProcessStoredProcedure4.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstoredprocedures/NewCustomerProcessV2StoredProcedure5.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstoredprocedures/NewOrderProcessStoredProcedure6.java inflating creating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstresstest/OrderEntryProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstresstest/ProcessOrdersStressTest.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstresstest/SalesRepsOrdersQueryStressTestDelete.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstresstest/UpdateCustomerDetailsV2StressTestInsert.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstresstest/WarehouseActivityQueryStressTestSelect.java inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionsstresstest/WarehouseOrdersQueryStressTestUpdate.java creating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/ inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/newStoredProcedureBrowseAndUpdateOrders.java inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/StoredProcedure1BrowseProducts.java inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/StoredProcedure2NewCustomerProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/StoredProcedure3NewOrderProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/StoredProcedure4OrderEntryProcess.java inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/StoredProcedure5ProcessOrders.java inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedurestransactions/StoredProcedure6SalesRepsOrdersQuery.java creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/stresstesttransactions/WarehouseActivityQuery.java inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstesttransactions/StressTestWarehouseOrdersQuery.java inflatingcreating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestDelete.javamike/ inflatingcreating: swingbench/source/com/dommike/benchmarking/swingbench/stresstest/StressTestInsert.javaCallingCircle/ inflatinginflating: swingbench/source/com/dommike/benchmarking/swingbench/stresstest/StressTestSelectCallingCircle/CallingCircleLineIdentifier.java inflating: swingbench/source/com/dommike/benchmarking/swingbench/stresstest/StressTestUpdateCallingCircle/CallingCircleProcess.java creatinginflating: swingbench/source/com/dommike/benchmarking/swingbench/transactions/CallingCircle/CallingLineIdentifier.java inflating: swingbench/source/com/dommike/benchmarking/swingbench/transactions/BrowseAndUpdateOrdersCallingCircle/CustomerAccount.java inflating: swingbench/source/com/dommike/benchmarking/swingbench/transactions/BrowseProductsCallingCircle/CustomerCallingLineIdentifier.java inflating: swingbench/source/com/dommike/benchmarking/swingbench/transactions/NewCustomerProcessCallingCircle/NewCallingCircleProcess.java inflating: swingbench/source/com/dommike/benchmarking/swingbench/transactions/NewOrderProcessCallingCircle/RetrieveHistoryProcess.java inflating: swingbench/source/com/dommike/benchmarking/swingbench/transactions/OrderEntryProcessCallingCircle/UpdateCallingCircleProcess.java inflatingcreating: swingbench/source/com/dom/benchmarking/swingbench/transactions/ProcessOrders.javasql/ inflating: swingbench/sql/analyzecc.sql inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/SalesRepsOrdersQuery.javasql/CreAppPkgBdy.sql inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/WarehouseActivityQuery.javasql/CreAppPkgHdr.sql inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/WarehouseOrdersQuery.javasql/CreAppPrc.sql creatinginflating: swingbench/source/com/mike/sql/CreData1.sql creatinginflating: swingbench/source/com/mike/CallingCircle/sql/CreData2.sql inflating: swingbench/source/com/mike/CallingCircle/CallingCircleLineIdentifier.javasql/CreData3.sql inflating: swingbench/source/com/mike/CallingCircle/CallingCircleProcess.javasql/CreDataPkgBdy.sql inflating: swingbench/source/com/mike/CallingCircle/CallingLineIdentifier.javasql/CreDataPkgHdr.sql inflating: swingbench/source/com/mike/CallingCircle/CustomerAccount.javasql/CreInds.sql inflatingextracting: swingbench/source/com/mike/CallingCircle/CustomerCallingLineIdentifier.javasql/CreInds2.sql inflating: swingbench/source/com/mike/CallingCircle/NewCallingCircleProcess.javasql/CreMiscPkgBdy.sql inflating: swingbench/source/com/mike/CallingCircle/RetrieveHistoryProcess.javasql/CreMiscPkgHdr.sql inflating: swingbench/source/com/mike/CallingCircle/UpdateCallingCircleProcess.javasql/CreTabs.sql creatinginflating: swingbench/sql/CreTspc.sql inflating: swingbench/sql/analyzeccCreUser.sql inflating: swingbench/sql/CreAppPkgBdyDropTabs.sql inflating: swingbench/sql/CreAppPkgHdrDropUser.sql inflating: swingbench/sql/CreAppPrcGenData.sql inflating: swingbench/sql/CreData1grantv$access.sql inflating: swingbench/sql/CreData2oepostinstall.sql inflating: swingbench/sql/CreData3sh.sqlxml inflating: swingbench/sql/CreDataPkgBdysh_dgcreateconstraints_with_indexes.sql inflating: swingbench/sql/CreDataPkgHdrshdg_analyzeschema.sql inflating: swingbench/sql/CreIndsshdg_analyzeschema2.sql extracting inflating: swingbench/sql/CreInds2shdg_createconstraints.sql inflating: swingbench/sql/CreMiscPkgBdyshdg_createloadviews.sql inflating: swingbench/sql/CreMiscPkgHdrshdg_createtablespace.sql inflating: swingbench/sql/CreTabsshdg_createuser.sql inflating: swingbench/sql/CreTspcshdg_drop.sql inflating: swingbench/sql/CreUsershdg_drop_load_views.sql inflating: swingbench/sql/DropTabsshdg_drop_range.sql inflating: swingbench/sql/DropUsershdg_droptablespace.sql inflating: swingbench/sql/GenDatashdg_dropuser.sql inflating: swingbench/sql/grantv$accessshdg_indexes.sql inflating: swingbench/sql/oepostinstallshdg_indexes_none.sql inflating: swingbench/sql/sh.xmlshdg_indexes_part.sql inflating: swingbench/sql/shshdg_dgcreateconstraintsindexes_withpart_indexespk.sql inflating: swingbench/sql/shdg_analyzeschemaindexes_pk.sql inflating: swingbench/sql/shdg_analyzeschema2localindexes.sql inflating: swingbench/sql/shdg_createconstraintsmergepartitions.sql inflating: swingbench/sql/shdg_createloadviewsmodify_indexes.sql inflating: swingbench/sql/shdg_createtablespacetables.sql inflating: swingbench/sql/shdg_createusertablesrange.sql inflating: swingbench/sql/shdg_droptidyup.sql inflating: swingbench/sql/shdg_drop_load_viewstimedimension.sql inflating: swingbench/sql/shdg_drop_range.sqlsoe.xml inflating: swingbench/sql/shdg_droptablespacesoe2.sqlxml inflating: swingbench/sql/shdgsoedg_modify_dropuserindexes.sql inflating: swingbench/sql/shdg_indexessoedganalyzeschema.sql inflating: swingbench/sql/shdg_indexes_nonesoedganalyzeschema2.sql inflating: swingbench/sql/shdg_indexes_partsoedgconstraints.sql inflating: swingbench/sql/shdg_indexes_part_pksoedgconstraints2.sql inflatingextracting: swingbench/sql/shdgsoedgconstraints_indexesnone_pk2.sql inflating: swingbench/sql/shdgsoedgconstraints_pk_localindexes2.sql inflating: swingbench/sql/shdg_mergepartitionssoedgcreatepartitionedtables.sql inflating: swingbench/sql/shdg_modify_indexessoedgcreatetables.sql inflating: swingbench/sql/shdg_tablessoedgcreatetables2.sql inflating: swingbench/sql/shdg_tablesrangesoedgcreatetablescomposite2.sql inflating: swingbench/sql/shdg_tidyup.soedgcreatetableshash2.sql inflating: swingbench/sql/shdg_timedimensionsoedgcreatetablespace.sql inflating: swingbench/sql/soesoedgcreateuser.xmlsql inflating: swingbench/sql/soe2soedgdrop.xmlsql inflating: swingbench/sql/soedg_modify_indexessoedgdrop2.sql inflating: swingbench/sql/soedganalyzeschemasoedgindexes.sql inflating: swingbench/sql/soedganalyzeschema2soedgindexes2.sql inflating: swingbench/sql/soedgconstraintssoedgindexes_none_2.sql inflating: swingbench/sql/soedgconstraints2soedgindexes_pk_2.sql extracting inflating: swingbench/sql/soedgconstraints_none_2soedgpackage.sql inflating: swingbench/sql/soedgconstraintssoedgpackage2_pk_2body.sql inflating: swingbench/sql/soedgcreatepartitionedtablessoedgpackage2_header.sql inflating: swingbench/sql/soedgcreatetablessoedgsequences.sql inflating: swingbench/sql/soedgcreatetables2soedgsequences2.sql inflating: swingbench/sql/soedgcreatetablescomposite2soedgsetupmetadata.sql inflating: swingbench/sql/soedgcreatetableshash2soedgsqlset.sql inflating: swingbench/sql/soedgcreatetablespacesoedgviews.sql inflating: swingbench/sql/soedgcreateusersoedroptablespace.sql inflating: swingbench/sql/soedgdropsoedropuser.sql inflating: swingbench/sql/soedgdrop2storedprocedures.sql inflating: swingbench/sql/soedgindexes.sqlswingbenchFAQ.pdf inflatingcreating: swingbench/sqlwinbin/soedgindexes2.sql inflating: swingbench/sql/soedgindexes_none_2.sqlwinbin/bmcompare.bat inflating: swingbench/sql/soedgindexes_pk_2.sqlwinbin/ccwizard.bat inflating: swingbench/sqlwinbin/soedgpackageccwizard.sqlxml inflating: swingbench/sqlwinbin/soedgpackage2_bodycharbench.sqlbat inflating: swingbench/sqlwinbin/soedgpackage2_headerclusteroverview.sqlbat inflating: swingbench/sqlwinbin/soedgsequencesclusteroverview.sqlxml inflating: swingbench/sqlwinbin/soedgsequences2coordinator.sqlbat inflating: creating: swingbench/sql/soedgsetupmetadata.sqlwinbin/data/ inflating: swingbench/sqlwinbin/data/soedgsqlset1000mostpopularadjectives.sqltxt inflating: swingbench/sqlwinbin/data/soedgviews1000mostpopularwords.sqltxt inflating: swingbench/sqlwinbin/data/soedroptablespace100mostpopularwords.sqltxt inflating: swingbench/winbin/sqldata/soedropusercatalogue.sqltxt inflating: swingbench/winbin/sqldata/storedprocedurescounties.sqltxt inflating: swingbench/winbin/data/swingbenchFAQcountries.pdftxt creatingextracting: swingbench/winbin/data/domains.txt inflating: swingbench/winbin/bmcomparedata/emails.battxt inflating: swingbench/winbin/ccwizarddata/lowerfirstnames.battxt inflating: swingbench/winbin/ccwizarddata/lowerlastnames.xmltxt inflating: swingbench/winbin/data/charbenchnames.battxt inflating: swingbench/winbin/clusteroverviewdata/nls.battxt inflating: swingbench/winbin/clusteroverview.xml inflating: swingbench/winbin/coordinator.bat creating: swingbench/winbin/data/data/productids.txt inflating: swingbench/winbin/data/1000mostpopularadjectivestitles.txt inflating: swingbench/winbin/data/1000mostpopularwordstowns.txt inflating: swingbench/winbin/data/100mostpopularwords.txt inflating: swingbench/winbin/data/catalogue.txt inflating: swingbench/winbin/data/counties.txt inflating: swingbench/winbin/data/countries.txt extracting: swingbench/winbin/data/domains.txt inflating: swingbench/winbin/data/emails.txt inflating: swingbench/winbin/data/lowerfirstnames.txt inflating: swingbench/winbin/data/lowerlastnames.txt inflating: swingbench/winbin/data/names.txt inflating: swingbench/winbin/data/nls.txt inflating: swingbench/winbin/data/productids.txt inflating: swingbench/winbin/data/titles.txt inflating: swingbench/winbin/data/towns.txt inflating: swingbench/winbin/minibench.bat inflating: swingbench/winbin/oewizard.bat inflating: swingbench/winbin/oewizard.xml inflating: swingbench/winbin/shwizard.bat inflating: swingbench/winbin/shwizard.xml inflating: swingbench/winbin/swingbench.bat inflating: swingbench/winbin/swingconfig.xml |
3. Move the swingbench directory
| No Format |
|---|
cd ~oracle
mv software/swingbench . |
4. Configure swingbench
a. Change the login defaults for oewizard.xml
| No Format |
|---|
cd ~oracle/swingbench/bin
vi oewizard.xml |
Change the defaults to the following:
| Code Block | ||
|---|---|---|
| ||
<DefaultParameters>
<Parameter Key="datatablespacesexists" Value="true"/>
<Parameter Key="password" Value="oe"/>
<Parameter Key="username" Value="oe"/>
<Parameter Key="datafile" Value="+DATA"/>
<Parameter Key="userexists" Value="true"/>
<Parameter Key="connectionstring" Value="//source/orcl"/>
<Parameter Key="connectiontype" Value="thin"/>
<Parameter Key="onlydropuser" Value="false"/>
<Parameter Key="operation" Value="create"/>
<Parameter Key="tablespace" Value="USERS"/>
<Parameter Key="dbausername" Value="sys as sysdba"/>
<Parameter Key="dbapassword" Value="oracle"/>
<Parameter Key="output" Value="Verbose"/>
</DefaultParameters> |
b. Change the login details for oeconfig.xml
| No Format |
|---|
cd ~oracle/swingbench/configs/
vi oeconfig.xml |
| No Format |
|---|
<Connection>
<UserName>oe</UserName>
<Password>oe</Password>
<ConnectString>//source/orcl</ConnectString>
<DriverType>Oracle jdbc Driver</DriverType>
</Connection> |
5. Create the initial swingbench tables and load them with data. This takes about 25 minutes to run. While it is running, there is no output.
| No Format |
|---|
cd ~oracle/swingbench/bin
./oewizard -cl -create -scale 1 -u oe -p oe -ts users -tc 16 -s
============================================
| 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 |
| Note |
|---|
The username is: oe The password is: oe The tablespace is: users |
6. Download and install scripts
| No Format |
|---|
cd ~oracle/swingbench
wget http://ww2.dbvisit.com/download/files/external/sw_generate_load.sh
chmod 750 sw_generate_load.sh |
...
/minibench.bat
inflating: swingbench/winbin/oewizard.bat
inflating: swingbench/winbin/oewizard.xml
inflating: swingbench/winbin/shwizard.bat
inflating: swingbench/winbin/shwizard.xml
inflating: swingbench/winbin/swingbench.bat
inflating: swingbench/winbin/swingconfig.xml |
3. Move the Swingbench directory to the right location.
| No Format |
|---|
mv swingbench ../ |
4. Swingbench should now be in the home directory of oracle.