日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

單項(xiàng)選擇題

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？（）  

A. V$SYSSTAT
B. V$SESSSTAT
C. V$RSRC_PLAN
D. V$RSRC_CONSUMER_GROUP

題目列表

你可能感興趣的試題

單項(xiàng)選擇題

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？（）  

A. The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
B. The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
C. The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
D. The second code will not execute because one resource plan cannot be used by more than one subplan.
微信掃碼免費(fèi)搜題