网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
下面有关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快照进行分析
热门标签
最新试卷