https://docs.oracle.com/cd/F19136_01/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-B3FED12D-DA2A-4A19-9C45-93FC32690822
https://docs.oracle.com/cd/F19136_01/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-4816CA07-1376-45FD-82D4-F9E332936683
sqlplus test/test@pdb11
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA();
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (
CONSUMER_GROUP => 'OLTP',
COMMENT => 'OLTP applications');
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING(
ATTRIBUTE => DBMS_RESOURCE_MANAGER.ORACLE_USER,
VALUE => 'SH',
CONSUMER_GROUP => 'OLTP');
END;
/
--スイッチ権限は不要
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN(
PLAN => 'DAYTIME',
COMMENT => 'More resources for OLTP applications');
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (
PLAN => 'DAYTIME',
GROUP_OR_SUBPLAN => 'OLTP',
COMMENT => 'OLTP group',
MGMT_P1 => 75);
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (
PLAN => 'DAYTIME',
GROUP_OR_SUBPLAN => 'OTHER_GROUPS',
COMMENT => 'This one is required',
MGMT_P1 => 10);
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA();
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA();
END;
/
select PLAN_ID,PLAN from DBA_RSRC_PLANS order by PLAN;
col PLAN for a30
col GROUP_OR_SUBPLAN for a20
select PLAN,GROUP_OR_SUBPLAN,TYPE,CPU_P1 from DBA_RSRC_PLAN_DIRECTIVES order by PLAN,GROUP_OR_SUBPLAN;
show parameter RESOURCE_MANAGER_PLAN
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'DAYTIME';
show parameter RESOURCE_MANAGER_PLAN
