网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
WhichthreemethodscanyouusetorunanAutomaticDatabaseDiagnosticMonitor(ADDM)analysisoveraspecifictimeperiod?()
A.EnterpriseManagerGUI
B.DBMS_TRACEpackageAPIs
C.DBMS_ADVISORpackageAPIs
D.DBMS_MONITORpackageAPIs
E.$ORACLE_HOME/rdbms/admin/addmrpt.sqlscript
参考答案
更多 “ WhichthreemethodscanyouusetorunanAutomaticDatabaseDiagnosticMonitor(ADDM)analysisoveraspecifictimeperiod?() A.EnterpriseManagerGUIB.DBMS_TRACEpackageAPIsC.DBMS_ADVISORpackageAPIsD.DBMS_MONITORpackageAPIsE.$ORACLE_HOME/rdbms/admin/addmrpt.sqlscript ” 相关考题
考题
ViewtheExhibitandexaminethecharacteristicsoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto，inordertofindinformationabouttablefragmentation？（）A.MemoryAdvisorB.SegmentAdvisorC.SQLTuningAdvisorD.SQLAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor（ADDM）
考题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?（）A. Set metric thresholdB. Implement Database Resource ManagerC. Enable resumable timeout for user sessionsD. Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
YouexecutedthefollowingPL/SQLblocksuccessfully：VARIABLEtnameVARCHAR2（20）BEGINdbms_addm.insert_finding_directive（NULL，DIR_NAME=’DetailCPUUsage’，FINDING_NAME=’CPUUsage’，MIN_ACTIVE_SESSIONS=0，MIN_PERC_IMPACT=90）；：tname：=’databaseADDMtask4’；dbms_addm.analyze_db（：tname，150，162）；END；/Thenyouexecutedthefollowingcommand：SQLSELECTdbms_addm.get_report（：tname）FROMDUAL；TheabovecommandproducesAutomaticDatabaseDiagnosticMonitor（ADDM）analysis（）A.withtheCPUUsagefindingifitislessthan90B.withouttheCPUUsagefindingifitislessthan90C.withtheCPUUsagefindingforsnapshotsbelow90D.withtheCPUUsagefindingforsnapshotsnotbetween150and162
考题
Exhibit：ViewtheExhibitandexaminethecharacteristicoftheUSERStablespace.YouobservethatalargevolumeofinsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto，inordertofindinformationabouttablefragmentation？（）A.MemoryAdvisorB.SegmentAdvisorC.SLQTuningAdvisorD.SLQAccessAdvisorE.AutomaticDatabaseDiagnosticMonitor（ADDM）
考题
YoucreateanewAutomaticDatabaseDiagnosticMonitor（ADDM）task：instance_analysis_mode_task.ToviewtheADDMreport，youusethefollowingcommand：SQLSELECTdbms_addm.get_report（’my_instance_analysis_mode_task’）FROMdual；YouwanttosuppressADDMoutputrelatingtoSegmentAdvisoractionsonuserSCOTT’ssegments.Whatwouldyoudotoachievethis？（）A.AddafindingdirectivefortheADDMtask.B.AddasegmentdirectivefortheADDMtask.C.AddaparameterdirectivefortheADDMtask.D.DisabletheSegmentAdvisorfromtheAutomaticMaintenanceTask.
考题
在oracle数据库中,关于数据库ADDM说法正确的两项是()。
A.ADDM的分析结果存储在AWR报告中B.如果需要，ADDM调用其他顾问，但不提供顾问建议C.ADDM运行在mmon自动采集AWR快照之后D.ADDM分析只提供诊断信息，但不提供建议E.ADDM分析需要最近的4个AWR快照
考题
下面有关AutomaticDatabaseDiagnosticMonitor(ADDM)的描述中,哪两项是正确的?()
A.ADDM可以调用其它建议如果需要，但是不会产生推荐建议B.ADDM是MMON进程在每次awr快照收集后自动运行C.ADDM至少需要4个awr快照进行分析D.ADDM分析结果存放在AutomaticWorkloadRepository中E.ADDM仅提供诊断分析，不提供建议
考题
下面有关Automatic Database Diagnostic Monitor(ADDM)的描述中,那两项是正确的?()
A.ADDM仅提供诊断分析，不提供建议B.ADDM分析结果存放在Automatic Workload Repository中C.ADDM是MMON进程在每次awr快照收集后自动运行D.ADDM可以调用其它建议如果需要，但是不会产生推荐建议E.ADDM至少需要4个awr快照进行分析
热门标签
最新试卷
