下面有关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快照进行分析