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

  • 1
  • 0
  • 约1.63万字
  • 约 41页
  • 2025-10-22 发布于北京
  • 举报

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

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

文档评论(0)

1亿VIP精品文档

相关文档