第34次活动:2017-11-20(星期一晚上7:00-9:30)
BEGINdbms_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;
页:
[1]