SQL> select a.initial_rsrc_consumer_group
  2    from dba_users a
  3    where a.username = 'SCOTT';
 
INITIAL_RSRC_CONSUMER_GROUP
------------------------------
DEFAULT_CONSUMER_GROUP
 
SQL> BEGIN
  2    Dbms_Resource_Manager.Create_Pending_Area();
  3    DBMS_RESOURCE_MANAGER.set_initial_consumer_group
  4       ('SCOTT', 'REPORTING');
  5    Dbms_Resource_Manager.Validate_Pending_Area();
  6    Dbms_Resource_Manager.Submit_Pending_Area();
  7    Dbms_Resource_Manager.Clear_Pending_Area();
  8  END;
  9  / 
 
PL/SQL procedure successfully completed.
 
SQL> select a.initial_rsrc_consumer_group
  2    from dba_users a
  3    where a.username = 'SCOTT';
 
INITIAL_RSRC_CONSUMER_GROUP
------------------------------
DEFAULT_CONSUMER_GROUP