Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Swingbench is a free load generator (and benchmarks) designed by Dominic Giles to stress test an Oracle database (10g,11g,12c). 

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

1. Download Swingbench

No Format
su - oracle
mkdir software
cd software
wget http://dominicgiles.com/swingbench/swingbench25909.zip

2. Unzip the software

No Format
unzip swingbench25909.zip
Archive:  swingbench25909.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/data/names.txt  
  inflating: swingbench/bin/data/nls.txt  
  inflating: swingbench/bin/data/productids.txt  
  inflating: swingbench/bin/data/titles.txt  
  inflating: swingbench/bin/data/towns.txt  
  inflating: swingbench/bin/minibench  
  inflating: swingbench/.DS_Storebin/oewizard  
     creatinginflating: swingbench/bin/oewizard.xml  
  inflating: swingbench/bin/bmcompareshwizard  
  inflating: swingbench/bin/ccconfigshwizard.xml  
  inflating: swingbench/bin/ccwizardswingbench  
  inflating: swingbench/bin/ccwizardswingconfig.xml  
   creating: swingbench/configs/
  inflating: swingbench/binconfigs/charbenchccconfig.xml  
  inflating: swingbench/binconfigs/clusteroverviewoeconfig.xml  
  inflating: swingbench/binconfigs/clusteroverviewshconfig.xml  
  inflating: swingbench/binconfigs/coordinatorspconfig.xml  
   creatinginflating: swingbench/bin/data/configs/stresstest.xml  
  inflating: swingbench/binconfigs/data/1000mostpopularadjectivesswingconfigv1.txtxml  
  inflating: swingbench/binconfigs/data/1000mostpopularwords.txtswingconfigv2.xml  
   inflatingcreating: swingbench/bin/data/100mostpopularwords.txtlauncher/
    inflating: swingbench/bin/data/catalogue.txtlauncher/commons-launcher.jar  
  inflating: swingbench/bin/datalauncher/countieslauncher.txtproperties  
  inflating: swingbench/binlauncher/data/countries.txtlauncher.xml  
  extractinginflating: swingbench/binlauncher/data/domains.txtLauncherBootstrap.class  
   inflatingcreating: swingbench/bin/data/emails.txtlib/
    inflatingcreating: swingbench/binlib/datalauncher/lowerfirstnames.txt
    inflating: swingbench/binlib/datalauncher/lowerlastnamesant-launcher.txtjar  
  inflating: swingbench/binlib/datalauncher/namesant.txtjar  
  inflating: swingbench/binlib/datalauncher/nlsxercesImpl.txtjar  
  inflating: swingbench/binlib/datalauncher/productidsxml-apis.txtjar  
  inflating: swingbench/binlib/data/titlesojdbc6.txtjar  
  inflating: swingbench/binlib/data/townsons.txtjar  
  inflating: swingbench/binlib/minibenchsimplefan.jar  
  inflating: swingbench/binlib/oewizardswingbench.jar  
  inflating: swingbench/binlib/oewizarducp.xmljar  
   inflatingcreating: swingbench/binlog/shwizard 
   inflating: swingbench/bin/shwizard.xml README.txt   
   creating: swingbench/source/
   inflating: swingbench/binsource/swingbenchantbuild  
  inflating: swingbench/binsource/swingconfigbuild.xml  
   creating: swingbench/configssource/com/
  inflating creating: swingbench/configs/ccconfig.xmlsource/com/dom/
    inflatingcreating: swingbench/configs/oeconfig.xml/source/com/dom/benchmarking/
    inflatingcreating: swingbench/source/configs/shconfig.xml  
  inflating: swingbench/configs/spconfig.xmlcom/dom/benchmarking/swingbench/
    inflatingcreating: swingbench/source/com/dom/benchmarking/swingbench/configsdsstransactions/stresstest.xml
    inflating: swingbench/configs/swingconfigv1.xmlsource/com/dom/benchmarking/swingbench/dsstransactions/PeriodToPeriodComparison.java  
  inflating: swingbench/configs/swingconfigv2.xml  
   creating: swingbench/launcher/
  inflating: swingbench/launcher/commons-launcher.jarsource/com/dom/benchmarking/swingbench/dsstransactions/ProductSalesRollupCube.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/launcherdsstransactions/launcherSalesByCountryForGivenYear.propertiesjava  
  inflating: swingbench/launcher/launcher.xmlsource/com/dom/benchmarking/swingbench/dsstransactions/SalesByQuarterCountry.java  
  inflating: swingbench/launcher/LauncherBootstrap.classsource/com/dom/benchmarking/swingbench/dsstransactions/SalesCubeByMonth.java  
   creatinginflating: swingbench/lib/source/com/dom/benchmarking/swingbench/dsstransactions/SalesHistory.java  
  creatinginflating: swingbench/lib/launcher//source/com/dom/benchmarking/swingbench/dsstransactions/SalesMovingAverage.java  
  inflating: swingbench/lib/launcher/ant-launcher.jarsource/com/dom/benchmarking/swingbench/dsstransactions/SalesRollupByMonth.java  
  inflating: swingbench/lib/launcher/ant.jarsource/com/dom/benchmarking/swingbench/dsstransactions/SimpleLookUp.java  
  inflating: swingbench/lib/launcher/xercesImpl.jarsource/com/dom/benchmarking/swingbench/dsstransactions/TopSalesWithinQuarter.java  
   inflatingcreating: swingbench/lib/launcher/xml-apis.jar/source/com/dom/benchmarking/swingbench/plsqltransactions/
    inflating: swingbench/lib/ojdbc6.jarsource/com/dom/benchmarking/swingbench/plsqltransactions/BrowseAndUpdateOrders.java  
  inflating: swingbench/lib/ons.jarsource/com/dom/benchmarking/swingbench/plsqltransactions/BrowseProducts.java  
  inflating: swingbench/lib/simplefan.jarsource/com/dom/benchmarking/swingbench/plsqltransactions/NewCustomerProcess.java  
  inflating: swingbench/libsource/com/dom/benchmarking/swingbench/plsqltransactions/NewCustomerProcessV2.jarjava  
  inflating: swingbench/lib/ucp.jar/source/com/dom/benchmarking/swingbench/plsqltransactions/NewOrderProcess.java  
   creatinginflating: swingbench/log/source/com/dom/benchmarking/swingbench/plsqltransactions/OrderEntryProcess.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/README.txt  plsqltransactions/ProcessOrders.java  
  creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/SalesRepsOrdersQuery.java  
  inflating: swingbench/source/antbuildcom/dom/benchmarking/swingbench/plsqltransactions/UpdateCustomerDetailsV2.java  
  inflating: swingbench/source/build.xml/com/dom/benchmarking/swingbench/plsqltransactions/WarehouseActivityQuery.java  
   creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/WarehouseOrdersQuery.java  
   creating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/
   creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/newStoredProcedure.java  
  creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure1.java  
  creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/StoredProcedure2.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/PeriodToPeriodComparisonStoredProcedure3.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/ProductSalesRollupCubeStoredProcedure4.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/SalesByCountryForGivenYearStoredProcedure5.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstoredprocedures/SalesByQuarterCountryStoredProcedure6.java  
   inflatingcreating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstresstest/SalesCubeByMonth.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstresstest/SalesHistoryStressTest.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstresstest/SalesMovingAverageStressTestDelete.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstresstest/SalesRollupByMonthStressTestInsert.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstresstest/SimpleLookUpStressTestSelect.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactionsstresstest/TopSalesWithinQuarterStressTestUpdate.java  
   creating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/BrowseAndUpdateOrders.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/BrowseProducts.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/NewCustomerProcess.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/NewCustomerProcessV2NewOrderProcess.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/NewOrderProcessOrderEntryProcess.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/OrderEntryProcessProcessOrders.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/ProcessOrdersSalesRepsOrdersQuery.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/SalesRepsOrdersQueryWarehouseActivityQuery.java  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactionstransactions/UpdateCustomerDetailsV2WarehouseOrdersQuery.java  
  inflating creating: swingbench/source/com/mike/
   creating: swingbench/source/com/dommike/benchmarking/swingbench/plsqltransactions/WarehouseActivityQueryCallingCircle/
  inflating: swingbench/source/com/mike/CallingCircle/CallingCircleLineIdentifier.java  
  inflating: swingbench/source/com/dommike/benchmarking/swingbench/plsqltransactions/WarehouseOrdersQueryCallingCircle/CallingCircleProcess.java  
   creatinginflating: swingbench/source/com/dommike/benchmarking/swingbench/storedprocedures/CallingCircle/CallingLineIdentifier.java  
  inflating: swingbench/source/com/dommike/benchmarking/swingbench/storedprocedures/newStoredProcedureCallingCircle/CustomerAccount.java  
  inflating: swingbench/source/com/dommike/benchmarking/swingbench/storedprocedures/StoredProcedure1CallingCircle/CustomerCallingLineIdentifier.java  
  inflating: swingbench/source/com/dommike/benchmarking/swingbench/storedprocedures/StoredProcedure2CallingCircle/NewCallingCircleProcess.java  
  inflating: swingbench/source/com/dommike/benchmarking/swingbench/storedprocedures/StoredProcedure3CallingCircle/RetrieveHistoryProcess.java  
  inflating: swingbench/source/com/dommike/benchmarking/swingbench/storedprocedures/StoredProcedure4CallingCircle/UpdateCallingCircleProcess.java  
  inflating creating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure5.javasql/
  inflating: swingbench/sql/analyzecc.sql  
  inflating: swingbench/sql/CreAppPkgBdy.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure6.javasql/CreAppPkgHdr.sql  
  inflating: swingbench/sql/CreAppPrc.sql  
   creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/sql/CreData1.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTest.javasql/CreData2.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestDelete.javasql/CreData3.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestInsert.javasql/CreDataPkgBdy.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestSelect.javasql/CreDataPkgHdr.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestUpdate.javasql/CreInds.sql  
 extracting: swingbench/sql/CreInds2.sql  
   creatinginflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/sql/CreMiscPkgBdy.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactionssql/BrowseAndUpdateOrdersCreMiscPkgHdr.javasql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/BrowseProducts.javasql/CreTabs.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/NewCustomerProcess.javasql/CreTspc.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/NewOrderProcess.javasql/CreUser.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/OrderEntryProcess.javasql/DropTabs.sql  
  inflating: swingbench/sql/DropUser.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/ProcessOrders.javasql/GenData.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/SalesRepsOrdersQuery.javasql/grantv$access.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/WarehouseActivityQuery.javasql/oepostinstall.sql  
  inflating: swingbench/source/com/dom/benchmarking/swingbench/transactionssql/WarehouseOrdersQuerysh.javaxml   
  creatinginflating: swingbench/source/com/mike/sql/sh_dgcreateconstraints_with_indexes.sql  
  creatinginflating: swingbench/source/com/mike/CallingCircle/sql/shdg_analyzeschema.sql  
  inflating: swingbench/source/com/mike/CallingCircle/CallingCircleLineIdentifier.javasql/shdg_analyzeschema2.sql  
  inflating: swingbench/source/com/mike/CallingCircle/CallingCircleProcess.javasql/shdg_createconstraints.sql  
  inflating: swingbench/source/com/mike/CallingCircle/CallingLineIdentifier.javasql/shdg_createloadviews.sql  
  inflating: swingbench/source/com/mike/CallingCircle/CustomerAccount.javasql/shdg_createtablespace.sql  
  inflating: swingbench/source/com/mike/CallingCircle/CustomerCallingLineIdentifier.javasql/shdg_createuser.sql  
  inflating: swingbench/source/com/mike/CallingCircle/NewCallingCircleProcess.javasql/shdg_drop.sql  
  inflating: swingbench/source/com/mike/CallingCircle/RetrieveHistoryProcess.javasql/shdg_drop_load_views.sql  
  inflating: swingbench/source/com/mike/CallingCircle/UpdateCallingCircleProcess.javasql/shdg_drop_range.sql  
   creatinginflating: swingbench/sql/shdg_droptablespace.sql  
  inflating: swingbench/sql/analyzeccshdg_dropuser.sql  
  inflating: swingbench/sql/CreAppPkgBdyshdg_indexes.sql  
  inflating: swingbench/sql/CreAppPkgHdrshdg_indexes_none.sql  
  inflating: swingbench/sql/CreAppPrcshdg_indexes_part.sql  
  inflating: swingbench/sql/CreData1shdg_indexes_part_pk.sql  
  inflating: swingbench/sql/CreData2shdg_indexes_pk.sql  
  inflating: swingbench/sql/CreData3shdg_localindexes.sql  
  inflating: swingbench/sql/CreDataPkgBdyshdg_mergepartitions.sql  
  inflating: swingbench/sql/CreDataPkgHdrshdg_modify_indexes.sql  
  inflating: swingbench/sql/CreIndsshdg_tables.sql  
 extracting inflating: swingbench/sql/CreInds2shdg_tablesrange.sql  
  inflating: swingbench/sql/CreMiscPkgBdyshdg_tidyup.sql  
  inflating: swingbench/sql/CreMiscPkgHdrshdg_timedimension.sql  
  inflating: swingbench/sql/CreTabssoe.sqlxml  
  inflating: swingbench/sql/CreTspcsoe2.sqlxml  
  inflating: swingbench/sql/CreUsersoedg_modify_indexes.sql  
  inflating: swingbench/sql/DropTabssoedganalyzeschema.sql  
  inflating: swingbench/sql/DropUsersoedganalyzeschema2.sql  
  inflating: swingbench/sql/GenDatasoedgconstraints.sql  
  inflating: swingbench/sql/grantv$accesssoedgconstraints2.sql  
  inflatingextracting: swingbench/sql/oepostinstallsoedgconstraints_none_2.sql  
  inflating: swingbench/sql/sh.xml soedgconstraints_pk_2.sql  
  inflating: swingbench/sql/sh_dgcreateconstraints_with_indexessoedgcreatepartitionedtables.sql  
  inflating: swingbench/sql/shdg_analyzeschemasoedgcreatetables.sql  
  inflating: swingbench/sql/shdg_analyzeschema2soedgcreatetables2.sql  
  inflating: swingbench/sql/shdg_createconstraintssoedgcreatetablescomposite2.sql  
  inflating: swingbench/sql/shdg_createloadviewssoedgcreatetableshash2.sql  
  inflating: swingbench/sql/shdg_createtablespacesoedgcreatetablespace.sql  
  inflating: swingbench/sql/shdg_createusersoedgcreateuser.sql  
  inflating: swingbench/sql/shdg_dropsoedgdrop.sql  
  inflating: swingbench/sql/shdg_drop_load_viewssoedgdrop2.sql  
  inflating: swingbench/sql/shdg_drop_rangesoedgindexes.sql  
  inflating: swingbench/sql/shdg_droptablespacesoedgindexes2.sql  
  inflating: swingbench/sql/shdgsoedgindexes_none_dropuser2.sql  
  inflating: swingbench/sql/shdgsoedgindexes_pk_indexes2.sql  
  inflating: swingbench/sql/shdg_indexes_nonesoedgpackage.sql  
  inflating: swingbench/sql/shdgsoedgpackage2_indexes_partbody.sql  
  inflating: swingbench/sql/shdg_indexes_part_pksoedgpackage2_header.sql  
  inflating: swingbench/sql/shdg_indexes_pksoedgsequences.sql  
  inflating: swingbench/sql/shdg_localindexessoedgsequences2.sql  
  inflating: swingbench/sql/shdg_mergepartitionssoedgsetupmetadata.sql  
  inflating: swingbench/sql/shdg_modify_indexessoedgsqlset.sql  
  inflating: swingbench/sql/shdg_tablessoedgviews.sql  
  inflating: swingbench/sql/shdg_tablesrangesoedroptablespace.sql  
  inflating: swingbench/sql/shdg_tidyupsoedropuser.sql  
  inflating: swingbench/sql/shdg_timedimensionstoredprocedures.sql  
  inflating: swingbench/sql/soe.xmlswingbenchFAQ.pdf  
   inflatingcreating: swingbench/sqlwinbin/soe2.xml  
  inflating: swingbench/sql/soedg_modify_indexes.sqlwinbin/bmcompare.bat  
  inflating: swingbench/sqlwinbin/soedganalyzeschemaccwizard.sqlbat  
  inflating: swingbench/sqlwinbin/soedganalyzeschema2ccwizard.sqlxml  
  inflating: swingbench/sqlwinbin/soedgconstraintscharbench.sqlbat  
  inflating: swingbench/sqlwinbin/soedgconstraints2clusteroverview.sqlbat  
  extractinginflating: swingbench/sql/soedgconstraints_none_2.sqlwinbin/clusteroverview.xml  
  inflating: swingbench/sql/soedgconstraints_pk_2.sqlwinbin/coordinator.bat  
   inflatingcreating: swingbench/sql/soedgcreatepartitionedtables.sql  winbin/data/
  inflating: swingbench/winbin/sqldata/soedgcreatetables1000mostpopularadjectives.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgcreatetables21000mostpopularwords.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgcreatetablescomposite2100mostpopularwords.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgcreatetableshash2catalogue.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgcreatetablespacecounties.sqltxt  
  inflating: swingbench/sqlwinbin/data/soedgcreateusercountries.sqltxt  
  inflatingextracting: swingbench/winbin/sqldata/soedgdropdomains.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgdrop2emails.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgindexeslowerfirstnames.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgindexes2lowerlastnames.sqltxt  
  inflating: swingbench/sql/soedgindexes_none_2.sqlwinbin/data/names.txt  
  inflating: swingbench/sql/soedgindexes_pk_2.sqlwinbin/data/nls.txt  
  inflating: swingbench/sqlwinbin/data/soedgpackageproductids.sqltxt  
  inflating: swingbench/winbin/sqldata/soedgpackage2_bodytitles.sqltxt  
  inflating: swingbench/sql/soedgpackage2_header.sqlwinbin/data/towns.txt  
  inflating: swingbench/sqlwinbin/soedgsequencesminibench.sqlbat  
  inflating: swingbench/sqlwinbin/soedgsequences2oewizard.sqlbat  
  inflating: swingbench/sqlwinbin/soedgsetupmetadataoewizard.sqlxml  
  inflating: swingbench/sqlwinbin/soedgsqlsetshwizard.sqlbat  
  inflating: swingbench/sqlwinbin/soedgviewsshwizard.sqlxml  
  inflating: swingbench/sqlwinbin/soedroptablespaceswingbench.sqlbat  
  inflating: swingbench/sqlwinbin/soedropuserswingconfig.sqlxml  

3. Move the swingbench directory

No Format
cd ~oracle
mv  inflating: swingbench/sql/storedprocedures.sql  
  inflating: swingbench/swingbenchFAQ.pdf  
   creating: swingbench/winbin/
  inflating: swingbench/winbin/bmcompare.bat  
  inflating: swingbench/winbin/ccwizard.batsoftware/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
languagexml
   <DefaultParameters>
      <Parameter Key="datatablespacesexists" Value="true"/>
    inflating: swingbench/winbin/ccwizard.xml <Parameter Key="password" Value="oe"/>
 inflating: swingbench/winbin/charbench.bat     inflating: swingbench/winbin/clusteroverview.bat<Parameter Key="username" Value="oe"/>
    inflating: swingbench/winbin/clusteroverview.xml <Parameter Key="datafile" Value="+DATA"/>
 inflating: swingbench/winbin/coordinator.bat    <Parameter  creating: swingbench/winbin/data/Key="userexists" Value="true"/>
  inflating: swingbench/winbin/data/1000mostpopularadjectives.txt     inflating: swingbench/winbin/data/1000mostpopularwords.txt<Parameter Key="connectionstring" Value="//source/orcl"/>
    inflating: swingbench/winbin/data/100mostpopularwords.txt  
  inflating: swingbench/winbin/data/catalogue.txt <Parameter Key="connectiontype" Value="thin"/>
       inflating: swingbench/winbin/data/counties.txt<Parameter Key="onlydropuser" Value="false"/>
    inflating: swingbench/winbin/data/countries.txt  
 extracting: swingbench/winbin/data/domains.txt  
  inflating: swingbench/winbin/data/emails.txt <Parameter Key="operation" Value="create"/>
       inflating: swingbench/winbin/data/lowerfirstnames.txt<Parameter Key="tablespace" Value="USERS"/>
    inflating: swingbench/winbin/data/lowerlastnames.txt  
  inflating: swingbench/winbin/data/names.txt <Parameter Key="dbausername" Value="sys as sysdba"/>
    inflating: swingbench/winbin/data/nls.txt  
  inflating: swingbench/winbin/data/productids.txt <Parameter Key="dbapassword" Value="oracle"/>
       inflating: swingbench/winbin/data/titles.txt<Parameter Key="output" Value="Verbose"/>
    inflating: swingbench/winbin/data/towns.txt  
  inflating: swingbench/winbin/minibench.bat</DefaultParameters>

b. Change the login details for oeconfig.xml

No Format
cd ~oracle/swingbench/configs/
vi oeconfig.xml
No Format
   <Connection>
     inflating: swingbench/winbin/oewizard.bat<UserName>oe</UserName>
     inflating: swingbench/winbin/oewizard.xml<Password>oe</Password>
     inflating: swingbench/winbin/shwizard.bat  
  inflating: swingbench/winbin/shwizard.xml <ConnectString>//source/orcl</ConnectString>
      <DriverType>Oracle inflating: swingbench/winbin/swingbench.bat jdbc Driver</DriverType>
   inflating: swingbench/winbin/swingconfig.xml  

...

</Connection>

 

5. Download and install scripts

No Format
cd ~oracle/swingbench
mv software/swingbench .

...

wget http://ww2.dbvisit.com/download/files/external/sw_generate_load.sh
chmod 750 sw_generate_load.sh