===== Resource Manager ===== ==== CDB Resource Plan ==== This will control the resource usage between pluggable databases. Package / Procedures DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE DBMS_RESOURCE_MANAGER.UPDATE_CDB_PLAN_DIRECTIVE DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN_DIRECTIVE Views DBA_CDB_RSRC_PLANS DBA_CDB_RSRC_PLAN_DIRECTIVES Examples BEGIN DBMS_RESOURCE_MANAGER.create_pending_area; DBMS_RESOURCE_MANAGER.create_cdb_plan( plan => 'example_cdb_plan', comment => 'A test CDB resource plan'); DBMS_RESOURCE_MANAGER.create_cdb_plan_directive( plan => 'example_cdb_plan', pluggable_database => 'pdb1', shares => 10, -- Number of shares (ie 10/25th) utilization_limit => 50, -- Percent of CDBs CPU allowed parallel_server_limit => 50); -- Percent of CDBs PARALLEL_SERVERS_TARGET available DBMS_RESOURCE_MANAGER.create_cdb_plan_directive( plan => 'example_cdb_plan', pluggable_database => 'pdb2', shares => 15, utilization_limit => 50, parallel_server_limit => 50); DBMS_RESOURCE_MANAGER.validate_pending_area; DBMS_RESOURCE_MANAGER.submit_pending_area; END; ==== Automatic Consumer Group Switching ==== SWITCH_GROUP can now be set to LOG_ONLY, so a potential switch is logged but not performed.\\ New parameters are SWITCH_IO_LOGICAL and SWITCH_ELAPSED_TIME.