The CREATE_CONSUMER_GROUP procedure is used to create a resource consumer group.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only 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 | User comments. |
Examples
obclient> BEGIN
DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP('group1','Transaction group');
END ;
obclient> BEGIN DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP('group2','O&M group');
END ;