Performance Improvement MethodsWord格式.docx
- 文档编号:15875810
- 上传时间:2022-11-16
- 格式:DOCX
- 页数:8
- 大小:22.06KB
Performance Improvement MethodsWord格式.docx
《Performance Improvement MethodsWord格式.docx》由会员分享,可在线阅读,更多相关《Performance Improvement MethodsWord格式.docx(8页珍藏版)》请在冰豆网上搜索。
∙TheOraclePerformanceImprovementMethod
∙EmergencyPerformanceMethods
TheOraclePerformanceImprovementMethod
OracleperformancemethodologyhelpsyoutopinpointperformanceproblemsinyourOraclesystem.Thisinvolvesidentifyingbottlenecksandfixingthem.Itisrecommendedthatchangesbemadetoasystemonlyafteryouhaveconfirmedthatthereisabottleneck.
Performanceimprovement,byitsnature,isiterative.Forthisreason,removingthefirstbottleneckmightnotleadtoperformanceimprovementimmediately,becauseanotherbottleneckmightberevealed.Also,insomecases,ifserializationpointsmovetoamoreinefficientsharingmechanism,thenperformancecoulddegrade.Withexperience,andbyfollowingarigorousmethodofbottleneckelimination,applicationscanbedebuggedandmadescalable.
Performanceproblemsgenerallyresultfromeitheralackofthroughput,unacceptableuser/jobresponsetime,orboth.Theproblemmightbelocalizedbetweenapplicationmodules,oritmightbefortheentiresystem.
Beforelookingatanydatabaseoroperatingsystemstatistics,itiscrucialtogetfeedbackfromthemostimportantcomponentsofthesystem:
theusersofthesystemandthepeopleultimatelypayingfortheapplication.Typicaluserfeedbackincludesstatementslikethefollowing:
∙"
Theonlineperformanceissobadthatitpreventsmystafffromdoingtheirjobs."
Thebillingruntakestoolong."
WhenIexperiencehighamountsofWebtraffic,theresponsetimebecomesunacceptable,andIamlosingcustomers."
Iamcurrentlyperforming5000tradesaday,andthesystemismaxedout.Nextmonth,werollouttoallourusers,andthenumberoftradesisexpectedtoquadruple."
Fromcandidfeedback,itiseasytosetcriticalsuccessfactorsforanyperformancework.Determiningtheperformancetargetsandtheperformanceengineer'
sexitcriteriamakemanagingtheperformanceprocessmuchsimplerandmoresuccessfulatalllevels.Thesecriticalsuccessfactorsarebetterdefinedintermsofrealbusinessgoalsratherthansystemstatistics.
Somerealbusinessgoalsforthesetypicaluserstatementsmightbe:
Thebillingrunmustprocess1,000,000accountsinathree-hourwindow."
AtapeakperiodonaWebsite,theresponsetimewillnotexceedfivesecondsforapagerefresh."
Thesystemmustbeabletoprocess25,000tradesinaneight-hourwindow."
Theultimatemeasureofsuccessistheuser'
sperceptionofsystemperformance.Theperformanceengineer'
sroleistoeliminateanybottlenecksthatdegradeperformance.Thesebottleneckscouldbecausedbyinefficientuseoflimitedsharedresourcesorbyabuseofsharedresources,causingserialization.Becauseallsharedresourcesarelimited,thegoalofaperformanceengineeristomaximizethenumberofbusinessoperationswithefficientuseofsharedresources.Ataveryhighlevel,theentiredatabaseservercanbeseenasasharedresource.Conversely,atalowlevel,asingleCPUordiskcanbeseenassharedresources.
TheOracleperformanceimprovementmethodcanbeapplieduntilperformancegoalsaremetordeemedimpossible.Thisprocessishighlyiterative,anditisinevitablethatsomeinvestigationswillbemadethathavelittleimpactontheperformanceofthesystem.Ittakestimeandexperiencetodevelopthenecessaryskillstoaccuratelypinpointcriticalbottlenecksinatimelymanner.However,priorexperiencecansometimesworkagainsttheexperiencedengineerwhoneglectstousethedataandstatisticsavailabletohim.Itisthistypeofbehaviorthatencouragesdatabasetuningbymythandfolklore.Thisisaveryrisky,expensive,andunlikelytosucceedmethodofdatabasetuning.
TheAutomaticDatabaseDiagnosticMonitor(ADDM)implementspartsoftheperformanceimprovementmethodandanalyzesstatisticstoprovideautomaticdiagnosisofmajorperformanceissues.UsingADDMcansignificantlyshortenthetimerequiredtoimprovetheperformanceofasystem.SeeChapter
6,"
AutomaticPerformanceDiagnostics"
foradescriptionofADDM.
Today'
ssystemsaresodifferentandcomplexthathardandfastrulesforperformanceanalysiscannotbemade.Inessence,theOracleperformanceimprovementmethoddefinesawayofworking,butnotadefinitivesetofrules.Withbottleneckdetection,theonlyruleisthattherearenorules!
Thebestperformanceengineersusethedataprovidedandthinklaterallytodetermineperformanceproblems.
StepsinTheOraclePerformanceImprovementMethod
1.Performthefollowinginitialstandardchecks:
a.Getcandidfeedbackfromusers.Determinetheperformanceproject'
sscopeandsubsequentperformancegoals,aswellasperformancegoalsforthefuture.Thisprocessis
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Performance Improvement Methods