Which three statements are true about adaptive SQL plan management?()A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.B. The optimizer always uses the fixe

题目
Which three statements are true about adaptive SQL plan management?()

A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.

C. It adds new, bettor plans automatically as fixed plans to the baseline.

D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

相似考题

1.Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements?（）A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B. Capture the plans from the previous version using STS and then load them into the stored outline.C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

2.Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE（PLAN=>’DSS_PLAN’，GROUP_OR_SUBPLAN=>’DSS_USERS’，NEW_CPU_P1=>80，NEW_SWITCH_GROUP=>’CANCEL_SQL’，NEW_SWITCH_ESTIMATE=>TRUE，NEW_SWITCH_TIME=>600）；Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds？（）

3.TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）A.ThestatementwilldeactivateDAY_PLAN.B.ThestatementwillactivateDAY_PLANasthetopplan.C.ThestatementwillactivateMANAGERS_PLANasthetopplan.D.ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.

4.Youexecutethefollowingblockofcode：SQL>BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’DEPARTMENTS’，CONSUMER_GROUP1=>’PAYROLLL’，GROUP1_CPU=>50，CONSUMER_GROUP2=>’SALES’，GROUP2_CPU=>25，CONSUMER_GROUP3=>’MARKETING’，GROUP3_CPU=>25）；END；SQL>/Whatisaprerequisiteforusingthesimpleresourceplancreatedbyexecutingtheabovecode？（）A.Youmustassignuserstoconsumergroups.B.Youmustgranttheswitchprivilegetotheusers.C.Youmustcreatearesourceplandirective.D.Youmustspecifythecomplexresourceplan.

更多“Which three statements are true about adaptive SQL plan management?() ”相关问题

  • 第1题：

    ExaminethefollowingPL/SQLblock：SETSERVEROUTPUTONSETLONG10000ECLAREreportclob；BEGINreport：=DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）；DBMS_OUTPUT.PUT_LINE（report）；END；WhichstatementdescribestheeffectoftheexecutionoftheabovePL/SQLblock？（）

    A.TheplanbaselinesareverifiedwiththeSQLprofiles.

    B.Allfixedplanbaselinesareconvertedintononfixedplanbaselines.

    C.AllthenonacceptedSQLprofilesareacceptedintotheplanbaseline.

    D.ThenonacceptedplansintheSQLManagementBaseareverifiedwiththeexistingplanbaselines.


    参考答案：D

  • 第2题：

    The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:（）

    A.2，4，5

    B.2，1，4，3，5

    C.1，2，3，4，5

    D.1，2，4，5


    参考答案：B

  • 第3题：

    Despite the wonderful acting and well-developed plot the _________ movie could not hold our attention.

    A) three-hours B) three-hour

    C) three-hours’ D) three-hour’s

     

     


    选B

     用破折号连接的作形容词不用复数.

  • 第4题：

    Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);Which two statements are true?（）

    A. Database operations will be monitored only when they consume a significant amount of resource.

    B. Database operations for all sessions will be monitored.

    C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.

    D. Only DML and DDL statements will be monitored for the session.

    E. All subsequent statements in the session will be treated as one database operation and will be monitored.


    参考答案：C, E

  • 第5题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）

    A. Execute the query and view Active Session History (ASH) for information about the query.

    B. Enable SQL trace for the query.

    C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    参考答案：C

  • 第6题：

    PleasechoosethecorrectdescriptionaboutCiscoSelf－DefendingNetworkcharacteristics.()

    A.INTEGRATED-P4S2，COLLABORATIVE-P4S1ADAPTIVE-P4S3

    B.INTEGRATED-P4S1，COLLABORATIVE-P4S2ADAPTIVE-P4S3

    C.INTEGRATED-P4S3，COLLABORATIVE-P4S2ADAPTIVE-P4S1

    D.INTEGRATED-P4S2，COLLABORATIVE-P4S3ADAPTIVE-P4S1


    参考答案：A

相关内容