DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_RSRC_CONSUMER_GROUPS

Object Details
Object Name: DBA_RSRC_CONSUMER_GROUPS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

all the resource consumer groups

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONSUMER_GROUP_ID NUMBER
Yes consumer group id
CONSUMER_GROUP VARCHAR2 (128)
consumer group name
CPU_METHOD VARCHAR2 (128)
deprecated - use MGMT_METHOD
MGMT_METHOD VARCHAR2 (128)
resource allocation method for the consumer group
INTERNAL_USE VARCHAR2 (3)
Whether the consumer group is for internal use-only
COMMENTS VARCHAR2 (2000)
Text comment on the consumer group
CATEGORY VARCHAR2 (128)
Category of the consumer group
STATUS VARCHAR2 (128)
PENDING if it is part of the pending area, NULL otherwise
MANDATORY VARCHAR2 (3)
Whether the consumer group is mandatory
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONSUMER_GROUP_ID
,      CONSUMER_GROUP
,      CPU_METHOD
,      MGMT_METHOD
,      INTERNAL_USE
,      COMMENTS
,      CATEGORY
,      STATUS
,      MANDATORY
FROM SYS.DBA_RSRC_CONSUMER_GROUPS;

Dependencies

[top of page]

SYS.DBA_RSRC_CONSUMER_GROUPS references the following:

SchemaSYS
TableRESOURCE_CONSUMER_GROUP$
SYS.DBA_RSRC_CONSUMER_GROUPS is referenced by following:

SchemaPUBLIC
SynonymDBA_RSRC_CONSUMER_GROUPS