Databases Reference
In-Depth Information
Resource plan definition
In this stage of development the plan directives are defined. You can edit the
directives by clicking on the edit action menu in the Consumer Group listing.
Directives associated with a Consumer Group are CPU emphasis, maximum degree
of parallelism, session pool (used to limit the maximum number of concurrent users
belonging to a specific consumer group), undo pool, maximum execution time,
consumer group switching and idle time.
This is the last step in configuring the Resource Manager elements. The next step
activates a specific plan.
Resource manager plan activation
There are several places where the plan can be activated, it can be done from
the Resource Plans window, the Resource Manager monitor or directly from the
SQL*Plus command line.
If you are using SQL*Plus CLI, and connected as a privileged user issue the
ALTER
SYSTEM
command:
Search WWH ::
Custom Search