本人想把用户kiki放在kiki_test资源消费组,然后给这个消费组指定了资源计划,但是启动资源计划以后,总是发现kiki用户处于other_groups组中,不论怎么弄老是这样。我怀疑dbms_resource_manager.set_consumer_group_mapping过程是否起左右,请高手看看,下面是有关脚本,很简单的。
begin
dbms_resource_manager.create_pending_area;
dbms_resource_manager.create_consumer_group(consumer_group=>'kiki_test',comment => 'kiki''s test consumer group');
dbms_resource_manager.set_consumer_group_mapping(attribute => dbms_resource_manager.oracle_user,value => 'kiki',consumer_group => 'kiki_test');
dbms_resource_manager.create_plan(plan => 'kiki_test_plan',comment => 'yin xue ju''s test plan');
dbms_resource_manager.create_plan_directive(plan => 'kiki_test_plan',group_or_subplan => 'sys_group',comment => '-------------',cpu_p1=>100);
dbms_resource_manager.create_plan_directive(plan => 'kiki_test_plan',group_or_subplan => 'kiki_test',comment => 'yxj ''s test plan directive',cpu_p2=>100,active_sess_pool_p1 => 2);
dbms_resource_manager.create_plan_directive(plan => 'kiki_test_plan',group_or_subplan => 'other_groups',comment => '-------------',cpu_p3=>100);
dbms_resource_manager.submit_pending_area;
end;
/
alter system set resource_manager_plan='kiki_test_plan';
SQL> select sid,username,resource_consumer_group from v$session where username='KIKI'
2;
SID USERNAME RESOURCE_CONSUMER_GROUP
---------- ------------------------------ --------------------------------
154 KIKI OTHER_GROUPS |