Databases Reference
In-Depth Information
Click on the
Consumer Groups
link, there you will find a button that creates the
groups. By clicking on the
Create
button a new window appears where the name of
the group (
Consumer
Group
) and an optional documentation text (
Description
) can
be entered. The scheduling policy is the resource allocation method for distributing
CPU among sessions in the consumer group. The default is
ROUND_ROBIN
, which uses
a round-robin scheduler to ensure that sessions are fairly executed. You can change
it to
RUN_TO_COMPLETION
; this scheduling method specifies that sessions with the
largest active time are scheduled ahead of other sessions.
Service mapping
Each service is mapped against a specific Resource Consumer Group; this allows
the user that connects through a given service to be automatically mapped against
a Consumer Group. The user must have the Resource Consumer Group granted;
otherwise the user will be mapped against the
DEFAULT_CONSUMER_GROUP
, no matter
which service it used to gain access to the database.
In order for the user to be granted permissions with the consumer group, the
permissions can be set either in the User configuration section in Enterprise Manager,
or using the
DBMS_RESOURCE_MANAGER.GRANT_SWITCH_CONSUMER_GROUP
stored unit.
Search WWH ::
Custom Search