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