The CREATE_CONSUMER_GROUP procedure creates a resource consumer group.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (
consumer_group IN VARCHAR2,
comment IN VARCHAR2 DEFAULT NULL);
Parameters
| Parameter | Description |
|---|---|
| consumer_group | The name of the resource consumer group. |
| comment | The comments. |
Examples
obclient> CALL DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP('group1','Transaction processing group');
Query OK, 0 rows affected
obclient> CALL DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP('group2','Routine O&M group');
Query OK, 0 rows affected
