對oracle使用者進行資源限制

select username,profile, INITIAL_RSRC_CONSUMER_GROUP from dba_users;

修改使用者的設定檔
alter user report profile LIMITUSER;
alter profile limituser  limit CONNECT_TIME UNLIMITED;

---修改使用者的資源消費者組

execute dbms_resource_manager_privs.grant_switch_consumer_group('REPORT','DEFAULT_CONSUMER_GROUP',FALSE);
execute dbms_resource_manager.set_initial_consumer_group('REPORT','DEFAULT_CONSUMER_GROUP');

select * from DBA_RSRC_CONSUMER_GROUPS;
select * from DBA_RSRC_GROUP_MAPPINGS;
select * from DBA_RSRC_PLANS;
select * from DBA_RSRC_PLAN_DIRECTIVES;