统计与等待分析及性能调优工具使用.pdfVIP

Objectives

Aftercompletingthisson,youshouldbeabletodo

thefollowing:

•Identifydynamicperformanceviewsusefulin

tuning

•Identifythekeytuningcomponentsofthealertlog

file

•Identifythekeytuningcomponentsofusertrace

fi

•Usedynamicperformanceviewstoviewstatistics

andwaitevents

PerformanceTuningData

Typeofdatahered:

•Cumulativestatistics:

–Waiteventswithtimeinformation

–Timemodel

•Metrics:Statisticrates

•Sampledstatistics:Activesessionhistory

–Statisticsbysession

–StatisticsbySQL

–Statisticsbyservice

–Otherdimensions

PerformanceTuningTools

Toolsthatareavailable:

•Basic:

–EnterpriseManagerpages

–Alertlog

–Tracefi

–Dynamicperformanceviewsandtab

•Add-in:

–Statspack

•Options:

–Diagnosticspack

–Tuningpack

AccessingtheDatabaseHomePage

name:1158/em

EMPerformancePages

ViewingtheAlertLog

DatabaseHomepageRelatedLinksregion

AlertLogContent

UsingAlertLogInformation

toAidinTuning

Thealertlogfilecontainsthefollowinginformation

thatcanbeusedtoaidintuningthedatabase:

pletecheckpoints

Timetoperformarchiving

Instancerecoverystartandcompletetimes

Deadlockandtimeouterrors

Checkpointstartandendtimes

UserTraceFi

•Server-processtracingcanbeenabledordisabled

atthesessionorinstancelevel.

•AusertracefilecontainsstatisticsfortracedSQL

statementsinthatsession.

•Usertracefiarecreatedonaperserver

processbasis.

•Usertraceficanalsobecreatedby:

–PerformingaBACKUPCON