第34次活动：2017-11-20（星期一晚上7:00-9:30）

botang

1. BEGIN
   
2. dbms_resource_manager.clear_pending_area();
   
3. dbms_resource_manager.create_pending_area();
   
4. dbms_resource_manager.create_plan( plan => 'PLAN2', comment => 'PLAN2', cpu_mth=>'RATIO' );
   
5. dbms_resource_manager.create_plan_directive(
   
6.     plan => 'PLAN2',
   
7.     group_or_subplan => 'SYS_GROUP',
   
8.     comment => 'SYS_GROUP',
   
9.     mgmt_p1 => 50
   
10. );
    
11. dbms_resource_manager.create_plan_directive(
    
12.     plan => 'PLAN2',
    
13.     group_or_subplan => 'GROUP1',
    
14.     comment => 'GROUP1',
    
15.     mgmt_p1 => 30
    
16. );
    
17. dbms_resource_manager.create_plan_directive(
    
18.     plan => 'PLAN2',
    
19.     group_or_subplan => 'GROUP2',
    
20.     comment => 'GROUP2',
    
21.     mgmt_p1 => 15
    
22. );
    
23. dbms_resource_manager.create_plan_directive(
    
24.     plan => 'PLAN2',
    
25.     group_or_subplan => 'OTHER_GROUPS',
    
26.     comment => 'OTHER_GROUPS',
    
27.     mgmt_p1 => 25
    
28. );
    
29. dbms_resource_manager.submit_pending_area();
    
30. END;
    
31. 
    
32. select  * from dba_rsrc_plans p
    
33. where p.plan='PLAN2';
    
34. 
    
35. select  * from dba_rsrc_plan_directives d
    
36.   where d.plan='PLAN2' ;
    
37.   
    
38. select s.USERNAME,s.RESOURCE_CONSUMER_GROUP, terminal
    
39. from v_$session s
    
40. where s.TERMINAL='pts/2';
    
41. 
    
42. select  * from dba_rsrc_plan_directives d
    
43.   where d.plan='PLAN1' ;
    
44.   
    
45. BEGIN
    
46. dbms_resource_manager.clear_pending_area();
    
47. dbms_resource_manager.create_pending_area();
    
48. dbms_resource_manager.update_plan_directive(
    
49.     plan => 'PLAN1',
    
50.     group_or_subplan => 'GROUP1',
    
51.     new_parallel_degree_limit_p1 => -1   
    
52. );
    
53. dbms_resource_manager.submit_pending_area();
    
54. END;
    
55. 
    
56. select  * from dba_rsrc_plan_directives d
    
57.   where d.plan='PLAN1' ;
    
58. 
    
59.   --------------------
    
60. create index i_big on t_big ( text , substr(dump(text), 1, 100 ) ,  substr(dump(text), 101, 100 )  ,substr(dump(text), 201,100) ,  owner , NAME , TYPE ,  LINE  )  parallel 20 ;
    
61. 
    
62. 
    
63. 
    
64. -----
    
65. 
    
66. select  * from dba_rsrc_plan_directives d
    
67.   where d.plan='PLAN1' ;
    
68.   
    
69. BEGIN
    
70. dbms_resource_manager.clear_pending_area();
    
71. dbms_resource_manager.create_pending_area();
    
72. dbms_resource_manager.update_plan_directive(
    
73.     plan => 'PLAN1',
    
74.     group_or_subplan => 'GROUP1',
    
75.     new_active_sess_pool_p1 => -1  ,
    
76.     new_queueing_p1=>-1
    
77. );
    
78. dbms_resource_manager.submit_pending_area();
    
79. END;
    
80. 
    
81. select  * from dba_rsrc_plan_directives d
    
82.   where d.plan='PLAN1' ;
    
83.   
    
84.   
    
85.   select s.USERNAME,s.RESOURCE_CONSUMER_GROUP, terminal
    
86. from v_$session s
    
87. where s.TERMINAL in ('pts/1', 'pts/3');
    
88. 
    
89. 
    
90. BEGIN
    
91. dbms_resource_manager.clear_pending_area();
    
92. dbms_resource_manager.create_pending_area();
    
93. dbms_resource_manager.create_plan( plan => 'PLAN1', comment => 'PLAN1' );
    
94. dbms_resource_manager.create_plan_directive(
    
95.     plan => 'PLAN1',
    
96.     group_or_subplan => 'SYS_GROUP',
    
97.     comment => 'SYS_GROUP',
    
98.     mgmt_p1 => 50
    
99. );
    
100. dbms_resource_manager.create_plan_directive(
     
101.     plan => 'PLAN1',
     
102.     group_or_subplan => 'GROUP1',
     
103.     comment => 'GROUP1',
     
104.     mgmt_p1 => 30
     
105. );
     
106. dbms_resource_manager.create_plan_directive(
     
107.     plan => 'PLAN1',
     
108.     group_or_subplan => 'GROUP2',
     
109.     comment => 'GROUP2',
     
110.     mgmt_p1 => 15
     
111. );
     
112. dbms_resource_manager.create_plan_directive(
     
113.     plan => 'PLAN1',
     
114.     group_or_subplan => 'OTHER_GROUPS',
     
115.     comment => 'OTHER_GROUPS',
     
116.     mgmt_p1 => 25
     
117. );
     
118. dbms_resource_manager.submit_pending_area();
     
119. END;
     
120. 
     
121. -----------------------
     
122. 
     
123. select  * from dba_rsrc_plan_directives d
     
124.   where d.plan='PLAN1' ;
     
125.   
     
126. BEGIN
     
127. dbms_resource_manager.clear_pending_area();
     
128. dbms_resource_manager.create_pending_area();
     
129. dbms_resource_manager.update_plan_directive(
     
130.     plan => 'PLAN1',
     
131.     group_or_subplan => 'GROUP1',
     
132.     new_undo_pool => -1
     
133. );
     
134. dbms_resource_manager.submit_pending_area();
     
135. END;
     
136. 
     
137. 
     
138. select  * from dba_rsrc_plan_directives d
     
139.   where d.plan='PLAN1' ;
     
140. 
     
141. BEGIN
     
142. dbms_resource_manager.clear_pending_area();
     
143. dbms_resource_manager.create_pending_area();
     
144. dbms_resource_manager.update_plan_directive(
     
145.     plan => 'PLAN1',group_or_subplan => 'GROUP1',
     
146.     new_switch_estimate=> false
     
147. );
     
148. dbms_resource_manager.submit_pending_area();
     
149. END;
     
150.   

复制代码