下载此文档

oracle 11g新特性之SQL Tuning.ppt

文档分类：IT计算机 | 页数：约22页举报非法文档有奖

1/22

下载提示

1.该资料是网友上传的，本站提供全文预览，预览什么样，下载就什么样。
2.下载该文档所得收入归上传者、原创者。
3.下载的文档，不会出现我们的网址水印。

同意并开始全文预览

(约 1-6 秒)

1/22 下载此文档

文档列表 文档介绍

oracle 11g新特性之SQL_Tuningpletingthislesson,youshouldbeableto:SetupandmodifyAutomaticSQLTuningUsethePL/eptprofilesGenerateSQLprofilesAutomaticAutomaticSQLTuninginOracleDatabase11gAWRAutomaticSQLTuningWorkloadReports1234DBATopSQLSummaryofAutomationinOracleDatabase11gTaskrunsautomatically(AUTOTASKframework)Workloadautomaticallychosen(noSQLTuningSet)SQLprofilesautomaticallytestedSQLprofilescanbeconfiguredforautomaticimplementationSQLstatementsautomaticallyretunediftheyregressReportingavailableoveranytimeperiodSelectingPotentialSQLStatementsforTuningAWRAvrgexecutionHourlyPullthetopqueriesfromthepastweekintofourbuckets:binefourbucketsintoone(assigningweights).windowPickcandidateSQLTuneS1TesteptP1TuneS2……AutomaticSQLTuningtaskOnehourmaximum(bydefault)AutomaticTuningProcessExistingprofile?ReplaceprofileYN3Xbenefit?3Xbenefit?eptprofileYIgnorenewprofileNNNewSQLprofileGATHER_STATS_JOBIndexesNotconsideredforautoimplementationStalestatsRestructureSQLConsideredforautoimplementationControllingtheAutomaticSQLTuningTaskAutotaskconfiguration:On/offswitchMaintenancewindowsrunningtuningtaskCPUresourceconsumptionoftuningtaskTaskparameters:SQLprofileimplementationautomatic/manualswitchGlobaltimelimitfortuningtaskPer-SQLtimelimitfortuningtaskTest-executemodedisabledtosavetimeMaximumnumberofSQLprofilesautomaticallyimplementedperexecutionaswellasoverallTaskexecutionexpirationperiod

oracle 11g新特性之SQL Tuning 来自淘豆网www.taodocs.com转载请标明出处.

oracle 11g新特性 之SQL Tuning.ppt

oracle 11g新特性之SQL Tuning.ppt