Database Reference
In-Depth Information
That's one CDB resource plan created. A resource plan is enabled by modifying the initialization parameter
resource_manager_plan
in the root, as shown here:
SYS@CDB$ROOT> select value from v$parameter
2 where name = 'resource_manager_plan';
VALUE
------------------------------------------------------------------------
SYS@CDB$ROOT> alter system set resource_manager_plan = 'swingbench_plan';
System altered.
SYS@CDB$ROOT> select value from v$parameter
2 where name = 'resource_manager_plan';
VALUE
------------------------------------------------------------------------
swingbench_plan
SYS@CDB$ROOT>
If it should turn out that the effect on your system is catastrophic, you could quickly revert back to the old status
by executing a corresponding alter system set resource_manager_plan reverting back to the old one.
Be careful with the automatic maintenance windows and scheduler jobs though. Oracle has resource plans
associated with maintenance windows that can enable a different resource plan. The default windows' definition can
be obtained from the dba_scheduler_windows dictionary view.
If the resource plan has changed because of a maintenance window you can see output similar to this in the
v$parameter view:
SYS@CDB$ROOT> select value from v$parameter
2 where name = 'resource_manager_plan';
VALUE
--------------------------------------------------
SCHEDULER[0x4211]:DEFAULT_MAINTENANCE_PLAN
You could do the same and create your own windows and associate a resource manager plan with them or use
the “force” keyword to prevent a resource plan from being replaced.
Viewing information about the CDB plans
A new class of views introduced in Oracle 12.1 allows you to view information about the CDB plans. The views all fall
into the DBA_CDB% class of views. At the time of this writing the following views existed:
•
DBA_CDB_RSRC_PLANS
•
DBA_CDB_RSRC_PLAN_DIRECTIVES
Search WWH ::
Custom Search