Differences

This shows you the differences between two versions of the page.

--- resourcemanager [2015/07/29 09:17] – created z0hpvk
+++ resourcemanager [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== Resource Manager =====
 ==== CDB Resource Plan ====
-This will control the resource usage between pluggable databases.\\
+This will control the resource usage between pluggable databases.
 Package / Procedures
 <code>DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN
-DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE</code>
+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</code>
 Views
-<code>DBA_CDB_RSRC_PLANS</code>
+<code>DBA_CDB_RSRC_PLANS
+DBA_CDB_RSRC_PLAN_DIRECTIVES</code>
+Examples
+<code>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;</code>
+==== 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.