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

VIEW: SYS.CDB_RSRC_CONSUMER_GROUPS

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

all the resource consumer groups in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_RSRC_CONSUMER_GROUPS;

Dependencies

[top of page]

SYS.CDB_RSRC_CONSUMER_GROUPS does not reference any database object

SYS.CDB_RSRC_CONSUMER_GROUPS is referenced by following:

SchemaPUBLIC
SynonymCDB_RSRC_CONSUMER_GROUPS