Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESOURCE_MANAGER, 19 of 19
This procedure lets you change the resource consumer group for all sessions with a given user ID. It also change the consumer group of any (PQ) slave sessions that are related to the top user session.
DBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_USER ( user IN VARCHAR2, consumer_group IN VARCHAR2);
Parameter | Description |
---|---|
user |
Name of the user. |
consumer_group |
Name of the consumer group to switch to. |
The SWITCH_CONSUMER_GROUP_FOR_SESS
and SWITCH_CONSUMER_GROUP_FOR_USER
procedures let you to raise or lower the allocation of CPU resources of certain sessions or users. This provides a functionality similar to the nice
command on UNIX.
These procedures cause the session to be moved into the newly specified consumer group immediately.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|