You have created a resource plan,PROD_DB_PLAN, that uses the RATIO policy. The following consumer groups andtheir respective plan directives have been assigned to this resource plan:Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as1.Which statement is correct in this scenario? A.The plan PROD_DB_PLAN can have subplans. B.The members of the HIGH_CG consumer groupwould get 10% of the CPU. C.The CPU allocation for the consumergroups would be based on the ratio defined for the CPU_P1. D.The CPU allocation would be equal betweenthe HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing forthe LOW_CGand OTHER_GROUPS consumer groups.
同问呀,答案是C
但是我实践了一下,A也是可以的,只要是在CPU_P1这个级别上去分配就可以
我猜出题人想表达的意思是:基于Ratio CPU的Plan,不能在CPU_P2这个级别上去分配;
所以并不是不能有subplan,而是不能有sub level for CPU,否则会报错:
ORA-29392: cpu parameters for level 2 for plan WORKDAY_PLAN must be zero