Feature
DBA_RSRC_CONSUMER_GROUPS displays information about all resource groups in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_RSRC_GROUP_MAPPINGS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| CONSUMER_GROUP_ID | NUMBER(38) | NO | The ID of the resource group. |
| CONSUMER_GROUP | VARCHAR2(128) | NO | The name of the resource group that the user is bound to. |
| CPU_METHOD | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_METHOD | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| INTERNAL_USE | VARCHAR2(3) | NO | Indicates whether the resource group is only for internal use. It is used only for compatibility and the value is fixed to NULL. |
| COMMENTS | VARCHAR2(2000) | YES | Comments for the resource group. |
| CATEGORY | VARCHAR2(128) | NO | The category of the resource group. It is used only for compatibility and the value is fixed to NULL. |
| STATUS | VARCHAR2(128) | NO | The status of the resource group. It is used only for compatibility and the value is fixed to NULL. |
| MANDATORY | VARCHAR2(3) | NO | Indicates whether the resource group is required. It is used only for compatibility and the value is fixed to NULL. |