资源描述：
《Statistics Package (STATSPACK) README_11.1.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、-----------------------------------------------------------------------Oracle11gServerRelease11.1Production-------------------------------------------------------------------------Copyright(c)1993,2007,Oracle.Allrightsreserved.Author:ConnieDialerisGreenContributors:CeciliaG
2、ervasio,GrahamWood,RussellGreen,PatrickTearle,HaraldEri,StefanPommerenk,VladimirBarrierePleaserefertotheOracle11gserverREADMEfileintherdbmsdocdirectory,forcopyright,disclosure,restrictions,warrant,trademark,disclaimer,andlicensinginformation.TheREADMEfileisREADME_RDBMS.HTM.
3、OracleCorporation,500OracleParkway,RedwoodCity,CA94065.-------------------------------------------------------------------------StatisticsPackage(STATSPACK)README(spdoc.txt)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~TABLEOFCONTENTS-----------------0.IntroductionandTer
4、minology1.EnterpriseManager(EM),AutomaticWorkloadRepository(AWR)andStatspack2.StatspackConfiguration2.1.DatabaseSpaceRequirements2.2.InstallingtheTool2.3.ErrorsduringInstallation3.Gatheringdata-takingasnapshot3.1.AutomatingStatspackStatisticsGathering3.2.Usingdbms_job4.Runn
5、ingthePerformancereports4.1.Runningtheinstancereport4.2.Runningtheinstancereportwhentherearemultipleinstances4.3.ConfiguringtheInstanceReport4.4.RunningtheSQLreport4.5.RunningtheSQLreportwhentherearemultipleinstances4.6.ConfiguringtheSQLreport4.7.Gatheringoptimizerstatistic
6、sonthePERFSTATschema5.Configuringtheamountofdatacaptured5.1.SnapshotLevel5.2.SnapshotSQLthresholds5.3.ChangingthedefaultvaluesforSnapshotLevelandSQLThresholds5.4.SnapshotLevels-details5.5.SpecifyingaSessionId5.6.InputParametersfortheSNAPandMODIFY_STATSPACK_PARAMETERSprocedu
7、res6.DBtime,,andTimeUnitsusedforPerformanceStatistics6.1.DBtimecomparedtoTotalCallTime6.2.TimeUnitsusedforPerformanceStatistics7.EventTimings8.ManagingandSharingperformancedata8.1.Baseliningperformancedata8.1.1.InputParametersfortheMAKE_BASELINEandCLEAR_BASELINEprocedureand
8、functionwhichacceptBeginandEndSnapIds8.1.2.InputParametersfortheMAKE_BASELINEandCL
