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.
正确答案:B
答案解析:有
微信扫一扫手机做题