Skip to content

Instantly share code, notes, and snippets.

@jcnars

jcnars/gist:ef740adc194d3f437209805f5394145a

Created June 27, 2023 16:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jcnars/ef740adc194d3f437209805f5394145a to your computer and use it in GitHub Desktop.
Save jcnars/ef740adc194d3f437209805f5394145a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
(venv) jcnarasimhan@hadr-crdhost:~/swingbench/swingbench/configs$ cat mntrlscan_soepdb_ac_highertimeouts.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<SwingBenchConfiguration xmlns="http://www.dominicgiles.com/swingbench/config">
<Name>Order Entry (JDBC)</Name>
<Comment>Simple Order Entry workload using client side JDBC calls for Appliction Continuity</Comment>
<Connection>
<UserName>soe</UserName>
<Password>enc(cw4Xx9RgsQA=)</Password>
<ConnectString>(DESCRIPTION= (TRANSPORT_CONNECT_TIMEOUT=5) (RETRY_COUNT=6) (FAILOVER=ON) (ADDRESS = (PROTOCOL = TCP) (HOST = mntrlscan.company.brisbane.com) (PORT = 1521) ) (CONNECT_DATA= (SERVER = DEDICATED) (SERVICE_NAME = soepdb_ac) ))</ConnectString>
<DriverType>Oracle jdbc Driver</DriverType>
<ConnectionPooling>
<PooledInitialLimit>40</PooledInitialLimit>
<PooledMinLimit>100</PooledMinLimit>
<PooledMaxLimit>100</PooledMaxLimit>
<PooledInactivityTimeOut>50</PooledInactivityTimeOut>
<PooledConnectionWaitTimeout>45</PooledConnectionWaitTimeout>
<PooledPropertyCheckInterval>10</PooledPropertyCheckInterval>
<PooledAbandonedConnectionTimeout>120</PooledAbandonedConnectionTimeout>
</ConnectionPooling>
<Properties>
<Property Key="FetchSize">20</Property>
<Property Key="FastFailover">true</Property>
<Property Key="AppContinuityDriver">true</Property>
<Property Key="StatementCaching">50</Property>
</Properties>
</Connection>
<Load>
<NumberOfUsers>60</NumberOfUsers>
<MinDelay>0</MinDelay>
<MaxDelay>0</MaxDelay>
<InterMinDelay>50</InterMinDelay>
<InterMaxDelay>500</InterMaxDelay>
<QueryTimeout>120</QueryTimeout>
<MaxTransactions>-1</MaxTransactions>
<RunTime>0:0</RunTime>
<LogonGroupCount>5</LogonGroupCount>
<LogonDelay>1000</LogonDelay>
<LogOutPostTransaction>false</LogOutPostTransaction>
<WaitTillAllLogon>false</WaitTillAllLogon>
<StatsCollectionStart>0:0</StatsCollectionStart>
<StatsCollectionEnd>0:0</StatsCollectionEnd>
<ConnectionRefresh>0</ConnectionRefresh>
<TransactionList>
<Transaction>
<Id>Customer Registration</Id>
<ShortName>NCR</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.NewCustomerProcess</ClassName>
<Weight>20</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Update Customer Details</Id>
<ShortName>UCD</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.UpdateCustomerDetails</ClassName>
<Weight>10</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Browse Products</Id>
<ShortName>BP</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.BrowseProducts</ClassName>
<Weight>10</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Order Products</Id>
<ShortName>OP</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.NewOrderProcess</ClassName>
<Weight>50</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Process Orders</Id>
<ShortName>PO</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.ProcessOrders</ClassName>
<Weight>5</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Browse Orders</Id>
<ShortName>BO</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.BrowseAndUpdateOrders</ClassName>
<Weight>15</Weight>
<Enabled>true</Enabled>
</Transaction>
<Transaction>
<Id>Sales Rep Query</Id>
<ShortName>SQ</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.SalesRepsOrdersQuery</ClassName>
<Weight>2</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Warehouse Query</Id>
<ShortName>WQ</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.WarehouseOrdersQuery</ClassName>
<Weight>1</Weight>
<Enabled>false</Enabled>
</Transaction>
<Transaction>
<Id>Warehouse Activity Query</Id>
<ShortName>WA</ShortName>
<ClassName>com.dom.benchmarking.swingbench.transactions.WarehouseActivityQuery</ClassName>
<Weight>1</Weight>
<Enabled>false</Enabled>
</Transaction>
</TransactionList>
<EnvironmentVariables>
<Variable Key="SOE_NLSDATA_LOC">data/nls.txt</Variable>
<Variable Key="SOE_PRODUCTSDATA_LOC">data/productids.txt</Variable>
<Variable Key="SOE_NAMESDATA_LOC">data/names.txt</Variable>
<Variable Key="COMMIT_CLIENT_SIDE">true</Variable>
</EnvironmentVariables>
</Load>
<Preferences>
<StartMode>manual</StartMode>
<Output>swingbench</Output>
<JumpToEvents>true</JumpToEvents>
<TimingsIncludeSleep>false</TimingsIncludeSleep>
<TimingsIn>milliseconds</TimingsIn>
<StatisticsLevel>simple</StatisticsLevel>
<OutputFile>results.xml</OutputFile>
<Charts DefaultChart="Overview"/>
<AllowedErrorCodes/>
<RefreshRate>2</RefreshRate>
<OverviewCharts>
<OverviewChart>
<Name>DML</Name>
<MinimumValue>0.0</MinimumValue>
<MaximumValue>9.223372036854776E18</MaximumValue>
<Displayed>true</Displayed>
</OverviewChart>
<OverviewChart>
<Name>Database Time</Name>
<MinimumValue>2.147483647E9</MinimumValue>
<MaximumValue>2.147483647E9</MaximumValue>
<Displayed>true</Displayed>
</OverviewChart>
<OverviewChart>
<Name>Users</Name>
<MinimumValue>2.147483647E9</MinimumValue>
<MaximumValue>2.147483647E9</MaximumValue>
<Displayed>false</Displayed>
</OverviewChart>
<OverviewChart>
<Name>Disk</Name>
<MinimumValue>2.147483647E9</MinimumValue>
<MaximumValue>2.147483647E9</MaximumValue>
<Displayed>false</Displayed>
</OverviewChart>
<OverviewChart>
<Name>CPU</Name>
<MinimumValue>0.0</MinimumValue>
<MaximumValue>100.0</MaximumValue>
<Displayed>true</Displayed>
</OverviewChart>
<OverviewChart>
<Name>Response Time</Name>
<MinimumValue>2.147483647E9</MinimumValue>
<MaximumValue>2.147483647E9</MaximumValue>
<Displayed>true</Displayed>
</OverviewChart>
<OverviewChart>
<Name>Transactions Per Second</Name>
<MinimumValue>2.147483647E9</MinimumValue>
<MaximumValue>2.147483647E9</MaximumValue>
<Displayed>true</Displayed>
</OverviewChart>
<OverviewChart>
<Name>Transactions Per Minute</Name>
<MinimumValue>2.147483647E9</MinimumValue>
<MaximumValue>2.147483647E9</MaximumValue>
<Displayed>true</Displayed>
</OverviewChart>
</OverviewCharts>
</Preferences>
</SwingBenchConfiguration>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment