Note
This view is introduced since OceanBase Database V3.2.4.
Purpose
This view displays information about all resource groups in the current tenant.
Columns
| Column | 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 | The comments on 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. |
Sample query
A user queries information about all resource groups in the current tenant.
obclient [SYS]> SELECT CONSUMER_GROUP_ID, CONSUMER_GROUP FROM SYS.DBA_RSRC_CONSUMER_GROUPS;
The query result is as follows:
+-------------------+----------------+
| CONSUMER_GROUP_ID | CONSUMER_GROUP |
+-------------------+----------------+
| 10000 | BIG_GROUP |
| 10001 | SMALL_GROUP |
+-------------------+----------------+
2 rows in set
References
To view the binding relationships between users and resource groups, see DBA_RSRC_GROUP_MAPPINGS.