Oreilly.Optimizing.Oracle.Performance

《Oreilly.Optimizing.Oracle.Performance》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、APractitioner'sGuidetoOptimizingResponseTimeOptimizingOraclePerformanceCaryMillsapwithJeffHoltch01//MSWord//5/20/03//Page1of32ABetterWaytoOptimizeFormanypeople,Oracleperformanceisaverydifficultproblem.Since1990,I’veworkedwiththousandsofprofessionalsengagedinperformanceimprovementprojectsfortheir

2、Oraclesystems.Oracleperformanceimprovementprojectsappeartoprogressthroughstandardstagesovertime.IthinkthenamesofthosestagesarestoredinavaultsomewherebeneathGeneva.IfIremembercorrectly,thestagesare:UnrestrainedoptimismInformedpessimismPanicDenialDespairUtterdespairMiseryandfamineForsomereason,myc

3、olleaguesandIarerarelyinvitedtoparticipateinaprojectuntilthemiseryandfaminestage.Hereiswhatperformanceimprovementprojectsoftenlooklikebythetimewearrive.Dotheysoundlikesituationsyou’veseenbefore?Technicalexpertsdisagreeoverrootcauses.Theseverityofaperformanceproblemisproportionaltothenumberofpeop

4、lewhoshowupatmeetingstotalkaboutit.It’saparticularlybadsignwhenseveraldifferentcompanies’“bestexperts”showupinthesamemeeting.Indozensofmeetingsthroughoutmycareer,I’veseenthe“bestexperts”fromvariousconsultingcompanies,computerandstoragesubsystemmanufacturers,softwarevendors,andnetworkproviderscon

5、venetodismantleaperformanceproblem.Inexactly100%ofthesemeetingsI’veattended,thesegroupshavearguedincessantlyovertheidentityofaperformanceproblem’srootcause.Forweeks.Howcandedicated,smart,1ch01//MSWord//5/20/03//Page2of32well-trainedprofessionalsalllookatthesamesystemandrenderdifferentopinions—of

6、tenevencontradictoryopinions—onwhat’scausingaperformanceproblem?Apparently,Oraclesystemperformanceisaverydifficultproblem.Expertsclaimexcellentprogress,whileusersseenoimprovement.ManyofmystudentsgrinwithmemorieswhenItellstoriesofconsultantswhoannounceproudlythattheyhaveincreasedsomestatisticmark

7、edly—maybetheyincreasedsomehitratioorreducedsomeextentcountorsomesuch—onlytobeconfrontedwiththeindignitythattheuserscan’ttellthatanythingisanybetteratall.Theusualresultofsuchanexperienceisalongreportfromtheconsultantexplaini