niusouti.com

Youupdatedtheresourceplandirectivefortheresourceconsumergroup,DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement:SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(PLAN=>’DSS_PLAN’,GROUP_OR_SUBPLAN=>’DSS_USERS’,NEW_CPU_

题目

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?()


相似考题