The CREATE_CONSUMER_GROUP procedure is used to create a resource user group.
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 user group. |
| comment | User 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','Daily maintenance group');
Query OK, 0 rows affected