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) |