单项选择题
A. You must assign users to consumer groups.
B. You must grant the switch privilege to the users.
C. You must create a resource plan directive.
D. You must specify the complex resource plan.
单项选择题 YourecentlyactivatedaresourceplannamedOLTP_PLANinyourdatabase.Severalusersareconcurrentlyrunninglongtransactions.YoudecidetomonitortheresourcemanagertodetermineiftheresourceallocationformulatedintheOLTP_PLANissufficientforpeakdatabasehours.WhichdynamicperformanceviewshouldyouusetodisplaytheCPUtimeconsumedbyallthesessionswithintheresourcegroups？（）
单项选择题 You have created a resource plan， DAY. You execute the following code： SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN => ’DAY’， COMMENT => ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN => ’DEPARTMENTS’， CPU_P1=0）； END； Then， you issue the following code： SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN => ’DAY’， COMMENT => ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN => ’DEVELOPERS’， CPU_P2=100）； END； What will be the impact of executing the above code？（）
单项选择题 Youarecreatingaresourceconsumergroupusingthe DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUPprocedure.Whichparameterwillyouusetodefinetheresourceschedulingmethodusedbetweensessionswithintheresourcegroup？（）