DBA_RSRC_CONSUMER_GROUPS
displays information about all resource consumer groups in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
CONSUMER_GROUP |
VARCHAR2(30) |
Name of the consumer group | |
CPU_METHOD |
VARCHAR2(30) |
CPU resource allocation method for the consumer group | |
COMMENTS |
VARCHAR2(2000) |
Text comment on the consumer group | |
STATUS |
VARCHAR2(30) |
PENDING , if consumer group is part of the pending area; NULL otherwise. |
|
MANDATORY |
VARCHAR2(3) |
Indicates whether the consumer group is mandatory (YES ) or not (NO ) |