Note
This view is available starting with V3.2.4.
Purpose
This view displays information about all resource groups in the current project.
Columns
| Type | Type | Nullable | Description |
|---|---|---|---|
| CONSUMER_GROUP_ID | bigint(20) | NO | The ID of the resource group. |
| CONSUMER_GROUP | varchar(128) | NO | The name of the consumer group to which the user is bound. |
| CPU_METHOD | varchar(128) | NO | This value is only for compatibility and is set to NULL. |
| MGMT_METHOD | varchar(128) | NO | This field is retained for compatibility and always has a value of NULL. |
| INTERNAL_USE | varchar(3) | NO | Indicates whether the resource group is used for internal purposes, for compatibility only. The value is fixed to NULL. |
| Comments | varchar(2000) | YES | Remarks about the resource group. |
| CATEGORY | varchar(128) | NO | The type of the resource group. For compatibility, the value of this field is currently fixed as NULL. |
| STATUS | varchar(128) | NO | The status of the resource group, used for compatibility. The value is fixed as NULL. |
| MANDATORY | varchar(3) | NO | Indicates whether this resource group is mandatory, and is used only for compatibility. The value is fixed to NULL. |
Sample query
The system tenant can query information about all resource groups in its own tenant.
obclient [oceanbase]> SELECT CONSUMER_GROUP_ID, CONSUMER_GROUP FROM oceanbase.DBA_RSRC_CONSUMER_GROUPS;
The query result is as follows:
+-------------------+-------------------+
| CONSUMER_GROUP_ID | CONSUMER_GROUP |
+-------------------+-------------------+
| 10001 | batch_group |
| 10000 | interactive_group |
+-------------------+-------------------+
2 rows in set