|
- BEGIN
- dbms_resource_manager.clear_pending_area();
- dbms_resource_manager.create_pending_area();
- dbms_resource_manager.create_plan( plan => 'PLAN2', comment => 'PLAN2', cpu_mth=>'RATIO' );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN2',
- group_or_subplan => 'SYS_GROUP',
- comment => 'SYS_GROUP',
- mgmt_p1 => 50
- );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN2',
- group_or_subplan => 'GROUP1',
- comment => 'GROUP1',
- mgmt_p1 => 30
- );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN2',
- group_or_subplan => 'GROUP2',
- comment => 'GROUP2',
- mgmt_p1 => 15
- );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN2',
- group_or_subplan => 'OTHER_GROUPS',
- comment => 'OTHER_GROUPS',
- mgmt_p1 => 25
- );
- dbms_resource_manager.submit_pending_area();
- END;
- select * from dba_rsrc_plans p
- where p.plan='PLAN2';
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN2' ;
-
- select s.USERNAME,s.RESOURCE_CONSUMER_GROUP, terminal
- from v_$session s
- where s.TERMINAL='pts/2';
-
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN1' ;
-
- BEGIN
- dbms_resource_manager.clear_pending_area();
- dbms_resource_manager.create_pending_area();
- dbms_resource_manager.update_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'GROUP1',
- new_parallel_degree_limit_p1 => -1
- );
- dbms_resource_manager.submit_pending_area();
- END;
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN1' ;
- --------------------
- 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 ;
- -----
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN1' ;
-
- BEGIN
- dbms_resource_manager.clear_pending_area();
- dbms_resource_manager.create_pending_area();
- dbms_resource_manager.update_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'GROUP1',
- new_active_sess_pool_p1 => -1 ,
- new_queueing_p1=>-1
- );
- dbms_resource_manager.submit_pending_area();
- END;
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN1' ;
-
-
- select s.USERNAME,s.RESOURCE_CONSUMER_GROUP, terminal
- from v_$session s
- where s.TERMINAL in ('pts/1', 'pts/3');
- BEGIN
- dbms_resource_manager.clear_pending_area();
- dbms_resource_manager.create_pending_area();
- dbms_resource_manager.create_plan( plan => 'PLAN1', comment => 'PLAN1' );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'SYS_GROUP',
- comment => 'SYS_GROUP',
- mgmt_p1 => 50
- );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'GROUP1',
- comment => 'GROUP1',
- mgmt_p1 => 30
- );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'GROUP2',
- comment => 'GROUP2',
- mgmt_p1 => 15
- );
- dbms_resource_manager.create_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'OTHER_GROUPS',
- comment => 'OTHER_GROUPS',
- mgmt_p1 => 25
- );
- dbms_resource_manager.submit_pending_area();
- END;
- -----------------------
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN1' ;
-
- BEGIN
- dbms_resource_manager.clear_pending_area();
- dbms_resource_manager.create_pending_area();
- dbms_resource_manager.update_plan_directive(
- plan => 'PLAN1',
- group_or_subplan => 'GROUP1',
- new_undo_pool => -1
- );
- dbms_resource_manager.submit_pending_area();
- END;
- select * from dba_rsrc_plan_directives d
- where d.plan='PLAN1' ;
- BEGIN
- dbms_resource_manager.clear_pending_area();
- dbms_resource_manager.create_pending_area();
- dbms_resource_manager.update_plan_directive(
- plan => 'PLAN1',group_or_subplan => 'GROUP1',
- new_switch_estimate=> false
- );
- dbms_resource_manager.submit_pending_area();
- END;
-
复制代码
|
|