下面有关AutomaticDatabaseDiagnosticMonitor(ADDM)的描述中,哪两项是正确的?() A.ADDM可以调用其它建议如果需要,但是不会产生推荐建议B.ADDM是MMON进程在每次awr快照收集后自动运行C.ADDM至少需要4个awr快照进行分析D.ADDM分析结果存放在AutomaticWorkloadRepository中E.ADDM仅提供诊断分析,不提供建议

下面有关AutomaticDatabaseDiagnosticMonitor(ADDM)的描述中,哪两项是正确的?()

A.ADDM可以调用其它建议如果需要,但是不会产生推荐建议

B.ADDM是MMON进程在每次awr快照收集后自动运行

C.ADDM至少需要4个awr快照进行分析

D.ADDM分析结果存放在AutomaticWorkloadRepository中

E.ADDM仅提供诊断分析,不提供建议


相关考题:

Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()A.MemoryAdvisorB.SegmentAdvisorC.SQLAccessAdvisorD.AutomaticWorkloadRepository(AWR)E.AutomaticDatabaseDiagnosticMonitor(ADDM)

ViewtheExhibitandexaminethecharacteristicsoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?()A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor(ADDM)

Youobservethatdatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason,youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto,inordertodeterminetherequiredsizeofthedatabasebuffercache?()A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor(ADDM)

YouworkasadatabaseadministratorforSupportcenter.cn.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()A.MemoryAdvisorsB.SegmentAdvisorsC.SQLTuningandAccessAdvisorsD.AutomatedWorkloadRepository(AWR)E.AutomaticDatabaseDiagnosticMonitor(ADDM)

Exhibit:ViewtheExhibitandexaminethecharacteristicoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto,inordertofindinformationabouttablefragmentation?()A.MemoryAdvisorB.SegmentAdvisorC.SLQTuningAdvisorD.SLQAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor(ADDM)

YouworkasadatabaseadministratorforCertkiller.com.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto,inordertodeterminetheappropriateindexes?()A.MemoryAdvisorsB.SegmentAdvisorsC.SQLTuningandAccessAdvisorsD.AutomatedWorkloadRepository(AWR)E.AutomaticDatabaseDiagnosticMonitor(ADDM)

Youobservethatadatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason,youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto,inordertodeterminethatrequiredsizeofthedatabasebuffercache?()A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor(ADDM)

Youhave100segmentsintheUSERStablespace.YougetanalertthattheUSERStablespaceisrunninglowonspace.Youdecidetoshrinksomesegments.Whichoptionwouldyouusetodeterminewhichsegmentstoshrink?() A.SegmentAdvisorB.SQLTuningAdvisorC.SQLAccessAdvisorD.SegmentResourceEstimationE.AutomaticDatabaseDiagnosticMonitor(ADDM)

下面有关Automatic Database Diagnostic Monitor(ADDM)的描述中,那两项是正确的?() A.ADDM仅提供诊断分析,不提供建议B.ADDM分析结果存放在Automatic Workload Repository中C.ADDM是MMON进程在每次awr快照收集后自动运行D.ADDM可以调用其它建议如果需要,但是不会产生推荐建议E.ADDM至少需要4个awr快照进行分析