Oracle 11gR2 I/O Performance Tuning: Using Solid State Drives - Page 3

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>