053-99

View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:
SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?
Exhibit:

A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

一个创建资源计划的步骤:
1.创建未决域
2.创建,修改,或者删除用户组
3.创建资源计划
4.创建资源计划指令
5.验证未决域
6.提交未决域
A.未决域必须手动提交,不会自动提交。错
B.这个存储过程是验证未决域中的修改,所以要在创建资源计划指令后执行。 B 错
CD 选项,这 2 个组都是不能删除的组,但是 SYS_GROUP 可以被 session-to–consumer 组映规则覆盖(SYS,SYSTEM 用户属于 SYS_GROUP),所以可以不指定资源计划指令,但是OTHER_GROUPS 必须在每个计划中指定资源计划指令,其不能用过映射规则明确的被分配给会话。 C 错,D 对

 

posted @ 2017-11-15 15:34  巴啦啦大魔王  阅读(130)  评论(0编辑  收藏  举报