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