You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  

You have created a resource plan， DAY. You execute the ...

单项选择题

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_RESOU...

单项选择题You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） 

Yousettheundopoolresourceplandirectivefortheconsumergro...

多项选择题You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）