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/bin/oewizard
inflating: swingbench/bin/oewizard.xml
inflating: swingbench/bin/shwizard
inflating: swingbench/bin/shwizard.xml
inflating: swingbench/bin/swingbench
inflating: swingbench/bin/swingconfig.xml
creating: swingbench/configs/
inflating: swingbench/configs/ccconfig.xml
inflating: swingbench/configs/oeconfig.xml
inflating: swingbench/configs/shconfig.xml
inflating: swingbench/configs/spconfig.xml
inflating: swingbench/configs/stresstest.xml
inflating: swingbench/configs/swingconfigv1.xml
inflating: swingbench/configs/swingconfigv2.xml
creating: swingbench/launcher/
inflating: swingbench/launcher/commons-launcher.jar
inflating: swingbench/launcher/launcher.properties
inflating: swingbench/launcher/launcher.xml
inflating: swingbench/launcher/LauncherBootstrap.class
creating: swingbench/lib/
creating: swingbench/lib/launcher/
inflating: swingbench/lib/launcher/ant-launcher.jar
inflating: swingbench/lib/launcher/ant.jar
inflating: swingbench/lib/launcher/xercesImpl.jar
inflating: swingbench/lib/launcher/xml-apis.jar
inflating: swingbench/lib/ojdbc6.jar
inflating: swingbench/lib/ons.jar
inflating: swingbench/lib/simplefan.jar
inflating: swingbench/lib/swingbench.jar
inflating: swingbench/lib/ucp.jar
creating: swingbench/log/
inflating: swingbench/README.txt
creating: swingbench/source/
inflating: swingbench/source/antbuild
inflating: swingbench/source/build.xml
creating: swingbench/source/com/
creating: swingbench/source/com/dom/
creating: swingbench/source/com/dom/benchmarking/
creating: swingbench/source/com/dom/benchmarking/swingbench/
creating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/PeriodToPeriodComparison.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/ProductSalesRollupCube.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SalesByCountryForGivenYear.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SalesByQuarterCountry.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SalesCubeByMonth.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SalesHistory.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SalesMovingAverage.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SalesRollupByMonth.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/SimpleLookUp.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/dsstransactions/TopSalesWithinQuarter.java
creating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/BrowseAndUpdateOrders.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/BrowseProducts.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/NewCustomerProcess.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/NewCustomerProcessV2.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/NewOrderProcess.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/OrderEntryProcess.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/ProcessOrders.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/SalesRepsOrdersQuery.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/UpdateCustomerDetailsV2.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/WarehouseActivityQuery.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/plsqltransactions/WarehouseOrdersQuery.java
creating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/newStoredProcedure.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure1.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure2.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure3.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure4.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure5.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/storedprocedures/StoredProcedure6.java
creating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/
inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTest.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestDelete.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestInsert.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestSelect.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/stresstest/StressTestUpdate.java
creating: swingbench/source/com/dom/benchmarking/swingbench/transactions/
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/BrowseAndUpdateOrders.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/BrowseProducts.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/NewCustomerProcess.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/NewOrderProcess.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/OrderEntryProcess.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/ProcessOrders.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/SalesRepsOrdersQuery.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/WarehouseActivityQuery.java
inflating: swingbench/source/com/dom/benchmarking/swingbench/transactions/WarehouseOrdersQuery.java
creating: swingbench/source/com/mike/
creating: swingbench/source/com/mike/CallingCircle/
inflating: swingbench/source/com/mike/CallingCircle/CallingCircleLineIdentifier.java
inflating: swingbench/source/com/mike/CallingCircle/CallingCircleProcess.java
inflating: swingbench/source/com/mike/CallingCircle/CallingLineIdentifier.java
inflating: swingbench/source/com/mike/CallingCircle/CustomerAccount.java
inflating: swingbench/source/com/mike/CallingCircle/CustomerCallingLineIdentifier.java
inflating: swingbench/source/com/mike/CallingCircle/NewCallingCircleProcess.java
inflating: swingbench/source/com/mike/CallingCircle/RetrieveHistoryProcess.java
inflating: swingbench/source/com/mike/CallingCircle/UpdateCallingCircleProcess.java
creating: swingbench/sql/
inflating: swingbench/sql/analyzecc.sql
inflating: swingbench/sql/CreAppPkgBdy.sql
inflating: swingbench/sql/CreAppPkgHdr.sql
inflating: swingbench/sql/CreAppPrc.sql
inflating: swingbench/sql/CreData1.sql
inflating: swingbench/sql/CreData2.sql
inflating: swingbench/sql/CreData3.sql
inflating: swingbench/sql/CreDataPkgBdy.sql
inflating: swingbench/sql/CreDataPkgHdr.sql
inflating: swingbench/sql/CreInds.sql
extracting: swingbench/sql/CreInds2.sql
inflating: swingbench/sql/CreMiscPkgBdy.sql
inflating: swingbench/sql/CreMiscPkgHdr.sql
inflating: swingbench/sql/CreTabs.sql
inflating: swingbench/sql/CreTspc.sql
inflating: swingbench/sql/CreUser.sql
inflating: swingbench/sql/DropTabs.sql
inflating: swingbench/sql/DropUser.sql
inflating: swingbench/sql/GenData.sql
inflating: swingbench/sql/grantv$access.sql
inflating: swingbench/sql/oepostinstall.sql
inflating: swingbench/sql/sh.xml
inflating: swingbench/sql/sh_dgcreateconstraints_with_indexes.sql
inflating: swingbench/sql/shdg_analyzeschema.sql
inflating: swingbench/sql/shdg_analyzeschema2.sql
inflating: swingbench/sql/shdg_createconstraints.sql
inflating: swingbench/sql/shdg_createloadviews.sql
inflating: swingbench/sql/shdg_createtablespace.sql
inflating: swingbench/sql/shdg_createuser.sql
inflating: swingbench/sql/shdg_drop.sql
inflating: swingbench/sql/shdg_drop_load_views.sql
inflating: swingbench/sql/shdg_drop_range.sql
inflating: swingbench/sql/shdg_droptablespace.sql
inflating: swingbench/sql/shdg_dropuser.sql
inflating: swingbench/sql/shdg_indexes.sql
inflating: swingbench/sql/shdg_indexes_none.sql
inflating: swingbench/sql/shdg_indexes_part.sql
inflating: swingbench/sql/shdg_indexes_part_pk.sql
inflating: swingbench/sql/shdg_indexes_pk.sql
inflating: swingbench/sql/shdg_localindexes.sql
inflating: swingbench/sql/shdg_mergepartitions.sql
inflating: swingbench/sql/shdg_modify_indexes.sql
inflating: swingbench/sql/shdg_tables.sql
inflating: swingbench/sql/shdg_tablesrange.sql
inflating: swingbench/sql/shdg_tidyup.sql
inflating: swingbench/sql/shdg_timedimension.sql
inflating: swingbench/sql/soe.xml
inflating: swingbench/sql/soe2.xml
inflating: swingbench/sql/soedg_modify_indexes.sql
inflating: swingbench/sql/soedganalyzeschema.sql
inflating: swingbench/sql/soedganalyzeschema2.sql
inflating: swingbench/sql/soedgconstraints.sql
inflating: swingbench/sql/soedgconstraints2.sql
extracting: swingbench/sql/soedgconstraints_none_2.sql
inflating: swingbench/sql/soedgconstraints_pk_2.sql
inflating: swingbench/sql/soedgcreatepartitionedtables.sql
inflating: swingbench/sql/soedgcreatetables.sql
inflating: swingbench/sql/soedgcreatetables2.sql
inflating: swingbench/sql/soedgcreatetablescomposite2.sql
inflating: swingbench/sql/soedgcreatetableshash2.sql
inflating: swingbench/sql/soedgcreatetablespace.sql
inflating: swingbench/sql/soedgcreateuser.sql
inflating: swingbench/sql/soedgdrop.sql
inflating: swingbench/sql/soedgdrop2.sql
inflating: swingbench/sql/soedgindexes.sql
inflating: swingbench/sql/soedgindexes2.sql
inflating: swingbench/sql/soedgindexes_none_2.sql
inflating: swingbench/sql/soedgindexes_pk_2.sql
inflating: swingbench/sql/soedgpackage.sql
inflating: swingbench/sql/soedgpackage2_body.sql
inflating: swingbench/sql/soedgpackage2_header.sql
inflating: swingbench/sql/soedgsequences.sql
inflating: swingbench/sql/soedgsequences2.sql
inflating: swingbench/sql/soedgsetupmetadata.sql
inflating: swingbench/sql/soedgsqlset.sql
inflating: swingbench/sql/soedgviews.sql
inflating: swingbench/sql/soedroptablespace.sql
inflating: swingbench/sql/soedropuser.sql
inflating: swingbench/sql/storedprocedures.sql
inflating: swingbench/swingbenchFAQ.pdf
creating: swingbench/winbin/
inflating: swingbench/winbin/bmcompare.bat
inflating: swingbench/winbin/ccwizard.bat
inflating: swingbench/winbin/ccwizard.xml
inflating: swingbench/winbin/charbench.bat
inflating: swingbench/winbin/clusteroverview.bat
inflating: swingbench/winbin/clusteroverview.xml
inflating: swingbench/winbin/coordinator.bat
creating: swingbench/winbin/data/
inflating: swingbench/winbin/data/1000mostpopularadjectives.txt
inflating: swingbench/winbin/data/1000mostpopularwords.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