This is done using the procedure UPDATE_CONSUMER_GROUP.

Let’s assume we want to modify the Consumer Group that we created in the previous step, which is NEW_GROUP,

and let’s assume we want to modify the Comment.

Here, we also need to activate and create the Pending Area.

DECLARE

CONSUMER_GROUP VARCHAR2(200);

NEW_COMMENT VARCHAR2(200);

BEGIN

CONSUMER_GROUP := 'NEW_GROUP';

NEW_COMMENT := 'NEW GROUP FOR ALL USERS';

SYS.DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA;

SYS.DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;

SYS.DBMS_RESOURCE_MANAGER.UPDATE_CONSUMER_GROUP ( CONSUMER_GROUP, NEW_COMMENT );

SYS.DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;

COMMIT;

END;

We have modified the Comment for the NEW_GROUP Consumer Group, and you can monitor it via the table DBA_RSRC_CONSUMER_GROUPS.