第59次：2015-09-09星期三

admin

1. select  * from dba_rsrc_plans;
   
2. 
   
3. select  * from dba_rsrc_plan_directives d where d.plan='PLAN1';
   
4. 
   
5. select  * from dba_rsrc_consumer_groups;
   
6. 
   
7. select  * from dba_rsrc_group_mappings;
   
8. 
   
9. ---
   
10. select  * from dba_rsrc_plans  where plan  like 'PLAN%';
    
11. 
    
12. 
    
13. BEGIN
    
14. dbms_resource_manager.clear_pending_area();
    
15. dbms_resource_manager.create_pending_area();
    
16. dbms_resource_manager.create_plan( plan => 'PLAN2', comment => 'PLAN2',CPU_MTH=>'RATIO' );
    
17. dbms_resource_manager.create_plan_directive(
    
18.     plan => 'PLAN2',
    
19.     group_or_subplan => 'SYS_GROUP',
    
20.     comment => 'SYS_GROUP',
    
21.     mgmt_p1 => 5);
    
22. dbms_resource_manager.create_plan_directive(
    
23.     plan => 'PLAN2',
    
24.     group_or_subplan => 'GROUP1',
    
25.     comment => 'GROUP1',
    
26.     mgmt_p1 => 3);
    
27. dbms_resource_manager.create_plan_directive(
    
28.     plan => 'PLAN2',
    
29.     group_or_subplan => 'GROUP2',
    
30.     comment => 'GROUP2',
    
31.     mgmt_p1 => 2);
    
32. dbms_resource_manager.create_plan_directive(
    
33.     plan => 'PLAN2',
    
34.     group_or_subplan => 'OTHER_GROUPS',
    
35.     comment => 'OTHER_GROUPS',
    
36.     mgmt_p1 => 1
    
37. );
    
38. dbms_resource_manager.submit_pending_area();
    
39. END;
    
40. 
    
41. select  s.USERNAME, s.RESOURCE_CONSUMER_GROUP
    
42. from v_$session s where s.TERMINAL='pts/5';
    
43. 
    
44. 
    
45. select  * from dba_users u where u.username='SH';
    
46. 
    
47. alter user sh identified by oracle_4U account unlock;
    
48. 
    
49. 
    
50. select  * from dba_rsrc_plans  where plan  like 'PLAN%';
    
51. 
    
52. select  * from dba_rsrc_plan_directives d where d.plan='PLAN1';
    
53. 
    
54. 
    
55. 
    
56. BEGIN
    
57. dbms_resource_manager.clear_pending_area();
    
58. dbms_resource_manager.create_pending_area();
    
59. dbms_resource_manager.create_plan( plan => 'PLAN2', comment => 'PLAN2',CPU_MTH=>'RATIO' );
    
60. dbms_resource_manager.create_plan_directive(
    
61.     plan => 'PLAN2',
    
62.     group_or_subplan => 'SYS_GROUP',
    
63.     comment => 'SYS_GROUP',
    
64.     mgmt_p1 => 5);
    
65. dbms_resource_manager.create_plan_directive(
    
66.     plan => 'PLAN2',
    
67.     group_or_subplan => 'GROUP1',
    
68.     comment => 'GROUP1',
    
69.     mgmt_p1 => 3);
    
70. dbms_resource_manager.create_plan_directive(
    
71.     plan => 'PLAN2',
    
72.     group_or_subplan => 'GROUP2',
    
73.     comment => 'GROUP2',
    
74.     mgmt_p1 => 2);
    
75. dbms_resource_manager.create_plan_directive(
    
76.     plan => 'PLAN2',
    
77.     group_or_subplan => 'OTHER_GROUPS',
    
78.     comment => 'OTHER_GROUPS',
    
79.     mgmt_p1 => 1
    
80. );
    
81. dbms_resource_manager.submit_pending_area();
    
82. END;
    
83. 
    
84. select  s.USERNAME, s.RESOURCE_CONSUMER_GROUP, s.status ,s.TERMINAL
    
85. from v_$session s where s.TERMINAL in ('pts/2');
    
86. 
    
87. 
    
88. select  * from dba_users u where u.username='SH';
    
89. 
    
90. alter user sh identified by oracle_4U account unlock;
    
91. 
    
92. BEGIN
    
93. dbms_resource_manager.clear_pending_area();
    
94. dbms_resource_manager.create_pending_area();
    
95. dbms_resource_manager.update_plan_directive(
    
96.     plan => 'PLAN1',
    
97.     group_or_subplan => 'GROUP1',
    
98.    new_max_idle_blocker_time =>-1
    
99. );
    
100. dbms_resource_manager.submit_pending_area();
     
101. END;
     
102. 
     
103. ----
     
104. 
     
105. select  * from dba_rsrc_plan_directives d where d.plan='PLAN1';
     
106. 
     
107. ---
     
108. 
     
109. select  * from resource_cost;
     
110. 
     
111. alter resource cost  CPU_PER_SESSION 10  LOGICAL_READS_PER_SESSION 5  ;
     
112. 
     
113. 
     
114. 
     

复制代码