第60次：2015-09-11 星期五

admin

1. 
   
2. SELECT name FROM v$rsrc_plan
   
3. WHERE is_top_plan = 'TRUE' AND cpu_managed = 'ON';
   
4. 
   
5. 
   
6. SELECT value FROM v$parameter
   
7.   WHERE name = 'cpu_count' AND (isdefault = 'FALSE' OR ismodified != 'FALSE');
   
8. 
   
9. select  * from v$rsrc_plan ;
   
10. 
    
11. select  * from V$RSRC_CONSUMER_GROUP;
    
12. 
    
13. 
    
14. select  p.max_utilization_limit from dba_rsrc_plan_directives p where p.plan='PLAN4';
    
15. 
    
16. begin
    
17.    dbms_resource_manager.create_simple_plan(
    
18.     SIMPLE_PLAN=>'PLAN4',
    
19.      CONSUMER_GROUP1=>'GROUP1',
    
20.      GROUP1_CPU=>70,
    
21.      CONSUMER_GROUP2=>'GROUP2',
    
22.      GROUP2_CPU=>30,
    
23.      GROUP1_PERCENT=>80,
    
24.      GROUP2_PERCENT=>60);
    
25.    end;
    
26.    
    
27.    begin
    
28.       dbms_resource_manager.create_pending_area;
    
29.       dbms_resource_manager.update_plan_directive(plan => 'PLAN4',
    
30.       group_or_subplan => 'GROUP1',new_max_utilization_limit => 80);
    
31.       dbms_resource_manager.submit_pending_area;
    
32.       
    
33.       end;
    
34.       
    
35.      ---
    
36.      
    
37.      select  s.USERNAME,s.RESOURCE_CONSUMER_GROUP
    
38.        from v_$session s where s.TERMINAL='pts/7';
    
39.       
    
40.        select  * from dba_rsrc_plan_directives p
    
41.          where p.plan='PLAN1' and p.group_or_subplan='GROUP2';
    
42.          
    
43.          
    
44.          
    

复制代码