问题:
You updated the resource plan directive for the resource consumer group, DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement:
SQL>EXEC DBMS_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);
A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds?()
A . The session is killed before starting the operation.
B . The session generates an error before starting the operation.
C . The session switches to the CANCEL_SQL resource consumer group before starting the operation.
D . The session hangs before starting the operation.
You updated the resource plan directive for the resource consumer group, DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement:
SQL>EXEC DBMS_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);
A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds?()
● 参考解析
本题暂无解析