Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted December 2, 2011

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

By Jim Czuprynski

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>


Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM