Resource Manager plan

由于ocm需要考试资源管理计划,，所以简单做个试验，实验步骤如下，主要用了几个dbms包，关键是把资源管理计划几个概念搞清楚，其他的只是调用几个包创建罢了：

create test users:   
        create user oltp identified by oracle;
        create user olap identified by oracle;

 

 

create consumer group:
        begin
            dbms_resource_manager.clear_pending_area();
            dbms_resource_manager.create_pending_area();
        end;
        /

        begin
            dbms_resource_manager.create_consumer_group(
                 consumer_group  =>'oltp_group',
                 comment         =>'oltp group');

            dbms_resource_manager.create_consumer_group(
                 consumer_group  =>'olap_group',
                 comment         =>'olap group');
        end;
        /

 

create resource plan:
        begin
          dbms_resource_manager.create_plan(
                plan             =>'wanggang',
                comment          =>'test');
        end;
        /

 

 

create plan directives:(note:must have other_groups for a new resource plan)
        begin
            dbms_resource_manager.create_plan_directive(
                 plan =>  'wanggang',              
                 group_or_subplan => 'oltp_group',
                 comment=>'oltp directive',
                 cpu_p1=>70,
                 active_sess_pool_p1=>1000);

            dbms_resource_manager.create_plan_directive(
                 plan =>  'wanggang',              
                 group_or_subplan => 'olap_group',
                 comment=>'oltp directive',
                 cpu_p2=>30,
                 active_sess_pool_p1=>1000);

            dbms_resource_manager.create_plan_directive(
                 plan =>  'wanggang',              
                 group_or_subplan => upper('other_groups'),
                 comment=>'other directive',
                 cpu_p3=>100,
                 active_sess_pool_p1=>1000);

        end;
        /

 

validate and submit plan:
    begin
        dbms_resource_manager.validate_pending_area;
        dbms_resource_manager.submit_pending_area;
    end;
    /

activate the resource plan:
        alter system set resource_manager_plan = 'wanggang';