Differences

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

--- resourcemanager [2015/07/29 09:24] – z0hpvk
+++ resourcemanager [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 14: / Line 14: @@
 Examples
 <code>BEGIN
-  DBMS_RESOURCE_MANAGER.clear_pending_area;
   DBMS_RESOURCE_MANAGER.create_pending_area;
@@ Line 24: / Line 23: @@
     plan                  => 'example_cdb_plan',
     pluggable_database    => 'pdb1',
-    shares                => 3,
+    shares                => 10,  -- Number of shares (ie 10/25th)
-    utilization_limit     => 100,
+    utilization_limit     => 50,  -- Percent of CDBs CPU allowed
-    parallel_server_limit => 100);
+    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                => 3,
+    shares                => 15,
-    utilization_limit     => 100,
+    utilization_limit     => 50,
-    parallel_server_limit => 100);
+    parallel_server_limit => 50);
   DBMS_RESOURCE_MANAGER.validate_pending_area;
   DBMS_RESOURCE_MANAGER.submit_pending_area;
-END;
+END;</code>
-/</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.