下面有关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仅提供诊断分析，不提供建议

相似考题

1.Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）A.MemoryAdvisorB.SegmentAdvisorC.SQLAccessAdvisorD.AutomaticWorkloadRepository（AWR）E.AutomaticDatabaseDiagnosticMonitor（ADDM）

2.Youobservethatdatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason，youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto，inordertodeterminetherequiredsizeofthedatabasebuffercache？（）A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor（ADDM）

3.YouworkasadatabaseadministratorforSupportcenter.cn.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）A.MemoryAdvisorsB.SegmentAdvisorsC.SQLTuningandAccessAdvisorsD.AutomatedWorkloadRepository（AWR）E.AutomaticDatabaseDiagnosticMonitor（ADDM）

4.ViewtheExhibitandexaminethecharacteristicsoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto，inordertofindinformationabouttablefragmentation？（）A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor（ADDM）

更多“下面有关AutomaticDatabaseDiagnosticMonitor(ADDM)的描述中,哪两项是正确的?() ”相关问题

  • 第1题：

    Exhibit：ViewtheExhibitandexaminethecharacteristicoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto，inordertofindinformationabouttablefragmentation？（）

    A.MemoryAdvisor

    B.SegmentAdvisor

    C.SLQTuningAdvisor

    D.SLQAccessAdvisor

    E.AutomaticDatabaseDiagnosticMonitor（ADDM）


    参考答案：B

  • 第2题：

    Youobservethatadatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason，youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto，inordertodeterminethatrequiredsizeofthedatabasebuffercache？（）

    A.MemoryAdvisor

    B.SegmentAdvisor

    C.SQLTuningAdvisor

    D.SQLAccessAdvisor

    E.AutomaticDatabaseDiagnosticMonitor（ADDM）


    参考答案：A

  • 第3题：

    下面有关Automatic Database Diagnostic Monitor(ADDM)的描述中,那两项是正确的?()

    A.ADDM仅提供诊断分析，不提供建议

    B.ADDM分析结果存放在Automatic Workload Repository中

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

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

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


    参考答案：B, C

  • 第4题：

    YouworkasadatabaseadministratorforCertkiller.com.Youfindthatreportsarerunningforalongtimeinyourdatawarehousingapplications.Yoususpectalackofindexesisthereasonfortheperformancedegradation.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）

    A.MemoryAdvisors

    B.SegmentAdvisors

    C.SQLTuningandAccessAdvisors

    D.AutomatedWorkloadRepository（AWR）

    E.AutomaticDatabaseDiagnosticMonitor（ADDM）


    参考答案：C

  • 第5题：

    Youhave100segmentsintheUSERStablespace.YougetanalertthattheUSERStablespaceisrunninglowonspace.Youdecidetoshrinksomesegments.Whichoptionwouldyouusetodeterminewhichsegmentstoshrink?()

    A.SegmentAdvisor

    B.SQLTuningAdvisor

    C.SQLAccessAdvisor

    D.SegmentResourceEstimation

    E.AutomaticDatabaseDiagnosticMonitor(ADDM)


    参考答案：A

相关内容