WhichthreemethodscanyouusetorunanAutomaticDatabaseDiagnosticMonitor(ADDM)analysisoveraspecifictimeperiod?()A.EnterpriseManagerGUIB.DBMS_TRACEpackageAPIsC.DBMS_ADVISORpackageAPIsD.DBMS_MONITORpackageAPIsE.$ORACLE_HOME/rdbms/admin/addmrpt.sqlscript

题目
WhichthreemethodscanyouusetorunanAutomaticDatabaseDiagnosticMonitor(ADDM)analysisoveraspecifictimeperiod?()

A.EnterpriseManagerGUI

B.DBMS_TRACEpackageAPIs

C.DBMS_ADVISORpackageAPIs

D.DBMS_MONITORpackageAPIs

E.$ORACLE_HOME/rdbms/admin/addmrpt.sqlscript

相似考题

1.FE端口的IP地址在()命令中被定义。A.ADDFECFGB.ADDH248LNKC.ADDM2LNKD.ADDM3LNK

2.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)

3.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：SQL>SELECTdbms_addm.get_report（：tname）FROMDUAL；TheabovecommandproducesAutomaticDatabaseDiagnosticMonitor（ADDM）analysis（）A.withtheCPUUsagefindingifitislessthan90B.withouttheCPUUsagefindingifitislessthan90C.withtheCPUUsagefindingforsnapshotsbelow90D.withtheCPUUsagefindingforsnapshotsnotbetween150and162

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

更多“WhichthreemethodscanyouusetorunanAutomaticDatabaseDiagnosticMonitor(ADDM)analysisoveraspecifictimeperiod?() ”相关问题

  • 第1题：

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

    A.MemoryAdvisor

    B.SegmentAdvisor

    C.SLQTuningAdvisor

    D.SLQAccessAdvisor

    E.AutomaticDatabaseDiagnosticMonitor（ADDM）


    参考答案：B

  • 第2题：

    在oracle数据库中,关于数据库ADDM说法正确的两项是()。

    A.ADDM的分析结果存储在AWR报告中

    B.如果需要，ADDM调用其他顾问，但不提供顾问建议

    C.ADDM运行在mmon自动采集AWR快照之后

    D.ADDM分析只提供诊断信息，但不提供建议

    E.ADDM分析需要最近的4个AWR快照


    参考答案：AC

  • 第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题：

    YoucreateanewAutomaticDatabaseDiagnosticMonitor（ADDM）task：instance_analysis_mode_task.ToviewtheADDMreport，youusethefollowingcommand：SQL>SELECTdbms_addm.get_report（’my_instance_analysis_mode_task’）FROMdual；YouwanttosuppressADDMoutputrelatingtoSegmentAdvisoractionsonuserSCOTT’ssegments.Whatwouldyoudotoachievethis？（）

    A.AddafindingdirectivefortheADDMtask.

    B.AddasegmentdirectivefortheADDMtask.

    C.AddaparameterdirectivefortheADDMtask.

    D.DisabletheSegmentAdvisorfromtheAutomaticMaintenanceTask.


    参考答案：B

  • 第5题：

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

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

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

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

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

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


    参考答案：BD

相关内容