Swingbench Application Workload Profile
<?xml version = '1.0' encoding = 'UTF-8'?>
<SwingBenchConfiguration xmlns="http://www.dominicgiles.com/swingbench/config">
<Name>Stored Procedures Benchmark</Name>
<Comment></Comment>
<Connection>
<UserName>sh</UserName>
<Password>sh</Password>
<ConnectString>//192.168.0.136/tpcdb</ConnectString>
<DriverType>Oracle10g Type IV jdbc driver (thin)</DriverType>
</Connection>
<Load>
<NumberOfUsers>50</NumberOfUsers>
<MinDelay>100</MinDelay>
<MaxDelay>3000</MaxDelay>
<QueryTimeout>0</QueryTimeout>
<MaxTransactions>0</MaxTransactions>
<RunTime>0:15</RunTime>
<LogonGroupCount>1</LogonGroupCount>
<LogonDelay>100</LogonDelay>
<LogOutPostTransaction>true</LogOutPostTransaction>
<WaitTillAllLogon>false</WaitTillAllLogon>
<StatsCollectionStart>0:0</StatsCollectionStart>
<StatsCollectionEnd>0:0</StatsCollectionEnd>
<TransactionList>
<Transaction>
<Id>Stored Procedure 1</Id>
<ShortName>SP1</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure1</ClassName>
<Weight>50</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 2</Id>
<ShortName>SP2</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure2</ClassName>
<Weight>50</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 3</Id>
<ShortName>SP3</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure3</ClassName>
<Weight>50</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 4</Id>
<ShortName>SP4</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure4</ClassName>
<Weight>50</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 5</Id>
<ShortName>SP5</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure5</ClassName>
<Weight>50</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 6</Id>
<ShortName>SP6</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure6</ClassName>
<Weight>50</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 7</Id>
<ShortName>SP7</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure7</ClassName>
<Weight>50</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Stored Procedure 8</Id>
<ShortName>SP8</ShortName>
<ClassName>com.dom.benchmarking.swingbench.storedprocedures.StoredProcedure8</ClassName>
<Weight>50</Weight>
<Enabled>false</Enabled>
</Transaction>
</TransactionList>
</Load>
<Database>
<SystemUserName>system</SystemUserName>
<SystemPassword>oracle</SystemPassword>
<PerformAWRSnapShots>true</PerformAWRSnapShots>
</Database>
<Preferences>
<StartMode>manual</StartMode>
<Output>swingbench</Output>
<JumpToEvents>true</JumpToEvents>
<TimingsIncludeSleep>false</TimingsIncludeSleep>
<TimingsIn>miliseconds</TimingsIn>
<StatisticsLevel>simple</StatisticsLevel>
<OutputFile>results.xml</OutputFile>
<Charts DefaultChart="Overview">
<Chart>
<Name>Transactions Per Minute</Name>
<Autoscale>true</Autoscale>
<MaximumValue>-1.0</MaximumValue>
<Logarithmic>false</Logarithmic>
</Chart>
<Chart>
<Name>Transaction Response Time</Name>
<Autoscale>true</Autoscale>
<MaximumValue>-1.0</MaximumValue>
<Logarithmic>true</Logarithmic>
</Chart>
<Chart>
<Name>DML Operations Per Minute</Name>
<Autoscale>true</Autoscale>
<MaximumValue>-1.0</MaximumValue>
<Logarithmic>false</Logarithmic>
</Chart>
</Charts>
<AllowedErrorCodes/>
<RefreshRate>5</RefreshRate>
</Preferences>
</SwingBenchConfiguration>