suitsoracle10g

SwingbenchDominicGilesOracleUK.
AgendaAbouttheauthorBriefHistoryOverviewofSwingbenchSwingbenchFamilySuppliedBenchmarksRunningandInstallingSwingbenchOtherUsefulToolsWhatNextQuestionsAbouttheAuthorAbouttheAuthorDominicGileshttp://www.
dominicgiles.
com18yearsatOracleUKDatabasespecialistTheUK"DatabaseSolutions"teamBriefHistoryBriefHistoryDevelopmentstartedoutofaneedtodemonstratealoadonRealApplicationClustersManyofthecommercialdatabasesolutionswheresimplyanoverkillandtoodifficulttoobtainItstartedasathrowawayprojectSwingbench2.
2iscurrentlyproductionSwingbench2.
3isnowfunctionallycomplete.
OverviewofSwingbenchOverviewofSwingbenchSimpletouseloadgeneratorforOracledatabasesThreedifferentfrontendsSwingbenchCharbenchMinibenchFourdifferentbenchmarks.
Trivialtoaddyouowntransactions.
WritteninJavasoshouldrunonanyplatformwitha1.
5JVM.
OverviewofSwingbenchTypicallyusedasastandaloneloadgeneratorHoweveraCoordinatorprocessallowsmultipleloadgeneratorstoworktogether.
ClusterOverviewaggregatesalloftheresultstogether.
Itsfree.
.
.
.
OverviewofSwingbenchoptionalsystemmonitoroptionalsystemmonitorreportsoncpuanddiskreportsoncpuanddiskjdbcbasedtransactionsjdbcbasedtransactionsSimpleArchitectureSingleinstancedatabaseSingleinstancedatabaseOverviewofSwingbenchoptionalsystemmonitoroptionalsystemmonitorreportsoncpuanddiskreportsoncpuanddiskjdbcbasedtransactionsjdbcbasedtransactionsAdvancedArchitectureClusterOverviewClusterOverviewandCoordinatorandCoordinatorMultipleinstancesofswingbenchMultipleinstancesofswingbenchClusteredDatabaseClusteredDatabaseSwingbenchFamilySwingbenchFamilySeveralfrontendstothesamekernelConfigurationsaresavedtoanxmlbasedfileXMLschemaincludedResultsaretypicallysavedinxmltoaresultsfileChoosethefrontendthatsuitsyourneedsSwingbenchFamilySwingbenchRichgraphicalfrontendRealtimechartingEditingofallconfigurationparameters(newin2.
3)UsefulfordemonstrationsSwingbenchFamilyMinibenchSmallfootprintgraphicalfrontendSimplerealtimechartingResultsofbenchmarkareplacedinfileUsefulforaccessingintheimpactofanoperationsuchasabackup.
SwingbenchFamilyCharbenchCharacterbasedCapableofvmstat/sarlikeoutputWiderangeofcommandlineoptionsUsedin"serious"benchmarkingtestsSwingbenchFamilyClusterOverviewRichgraphicalfrontendRealtimechartingTypicallyusedtotestOracleRealApplicationClustersCanbeusedtocoordinatelargeloadsagainstlargeSMPmachines.
ScreenShotneededScreenShotneededWhatsNewin2.
3UpdatedUIforMinibenchandSwingbenchImprovedoverviewchartTimesTensupportBenchmarkwindowsJobsMorecommandlineoptionsDSSbenchmarkFasterbenchmarkschemacreationQuickdemoofSwingbenchSuppliedBenchmarksSuppliedBenchmarksSwingbenchcomeswithfourbenchmarksConfigurationfileslocatedinthesampledirectoryBenchmarkDescriptionRead/WriteRatio60/40CallingCircle70/30StressTest50/50SalesHistoryDSSbenchmark100/0OrderEntryClassicOrderEntryBenchmark.
TPC-CLikeTelcobasedselfserviceapplicationSimpleInsert/Update/Delete/SelectbenchmarkBenchmarksOrderEntryTPC-CLike.
UsesOracle10g's"oe"schemaasitsbasisGrowsovertimeDoesnotrequirepre-generationofdataforthebenchmark.
StoredprocedureandnativecodeversionsChoiceofusingpartitioningMaximumsize100GB**Ifusingtheorderentrycreationwizard*Ifusingtheorderentrycreationwizard*Wizardscanberunin"lightsout"(character)mode*Wizardscanberunin"lightsout"(character)modeBenchmarksCallingCircleTelcobasedselfservicebenchmarkRelativelystaticinsizeRequiresthegenerationofanewsetofdatafilesforeachnewbenchmarkrunTheschemawilleventuallybecome"wornout"andwillneedtoberebuildMaximumsize100GB*Ifusingtheorderentrycreationwizard*Ifusingtheorderentrycreationwizard*Wizardscanberunin"lightsout"(character)mode*Wizardscanberunin"lightsout"(character)modeBenchmarksStressTestSimplestofallthebenchmarksPerformssimpleInsert/Update/Delete/SelectoperationsSchemacreatedatruntimeUsefulforquicktestsCanberunagainstTimesTen*Ifusingtheorderentrycreationwizard*IfusingtheorderentrycreationwizardBenchmarksDSSADataWarehousingclassbenchmarkStillundertestingBasedontheOracle10g"SalesHistory"schemaNowizardatpresentPrioritytobuildoneUses"Datagenerator"topopulatethedatabase.
ScriptsshipwithDatageneratorMaximumsizelimitedbydiskandtimeBenchmarksDevelopingyourownSwingbenchshipswitha"blank"benchmarkthatcallsastoredprocedurewhichcanbemodifiedtoincludeyourowntransactionsTheJavasourceforallthetransactionsisshippedwithswingbench.
An"Ant"scriptwillcompileyournewormodifiedtransactionsSimpleJavaAPIallowsforthecreationofnewtransactionsRunningandInstallingSwingbenchRunningandInstallingSwingbenchInstallationrequiresthemodificationofeithertheswingbench.
envfileorswingbenchenv.
batfileSimplysettheSWINGHOMEandJAVAHOMEtoreflectyourenvironmentLinux/UnixexecutablesareinthebindirectoryWindowsareinthewinbindirectoryDownloadfromhttp://www.
dominicgiles.
comhttp://www.
dominicgiles.
comRunningandInstallingSwingbenchSwingbench,MinibenchandCharbenchcanalloverridesettingsinsideoftheconfigurationfilefromthecommandline.
$>.
/swingbench-csample/ccconfig.
xml-rt1:30-a$>.
/swingbench-csample/ccconfig.
xml-rt1:30-aYou'llneedtousedoublequotesonsomecommandsonWindowsC:\>charbench.
bat-a-v"users,tpm,tps"-rt0:15C:\>charbench.
bat-a-v"users,tpm,tps"-rt0:15RunningandInstallingSwingbenchItspossibletocomparetheresultsofseveralrunswiththebmcomparetool$>.
/bmcompare-rresults.
xml,results0001.
xml$>.
/bmcompare-rresults.
xml,results0001.
xmlThiswillcreateahtmlfilewithacomparisonofseveralrunsOtherUsefulToolsOtherUsefulToolsTosupportvariousaspectsofcurrentandfuturefunctionalityTraceAnalyzerandDatageneratorcameintoexistenceDatageneratorisdesignedtoreverseengineersimpleschemasandgeneratedummydataTraceAnalyzerisdesignedtoparseSQLtracefilesInfutureitwillcreatetransactionsforSwingbenchDatageneratorTraceAnalyzerWhatNextSwingbench2.
3isfunctionallycompleteTesting,BugFixing,Documentation,ViewletsTestingoftheDSSschemaatlargescaleWhatNextSwingbench2.
4WizardfortheDSSbenchmarkTimesTen/OracleBenchmarkApplicationserverbasedversionofSwingbenchTraceAnalyzerimprovementsMergeClusterOverviewwithSwingbenchQuestions