Home » RDBMS Server » Server Administration » how to set initial_rsrc_consumer_group (11.1.0.7 windows)
how to set initial_rsrc_consumer_group [message #515685] Tue, 12 July 2011 22:24
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I want to set initial_rsrc_consumer_group values to REPORTING for user scott,but it can not,why?


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





Previous Topic: Unable to increase SGA_MAX_SIZE
Next Topic: creating database(4 Merged)
Goto Forum:
  


Current Time: Sun Dec 28 03:36:37 CST 2014

Total time taken to generate the page: 0.07226 seconds