Database Administration (MOSC)

MOSC Banner

Resource plan managment issue

edited Feb 19, 2020 4:10AM in Database Administration (MOSC) 3 commentsAnswered
hi !

i am trying to create a resource group to control the parallel execution of processes.  for this i have created a group and mapped user to it but getting error in creating a plan.

/* create resource group for parallel queries
BEGIN
dbms_resource_manager.clear_pending_area();
dbms_resource_manager.create_pending_area();
dbms_resource_manager.create_consumer_group(consumer_group =>'PARALLEL_GRP',comment =>'resource group for parallel queries');
dbms_resource_manager.submit_pending_area();
END;
/

/* assign users to this group

BEGIN
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP ( 'PATRON', 'PARALLEL_GRP', true);
END;
/
OR
exec dbms_resource_manager.set_initial_consumer_group ('PATRON','PARALLEL_GRP');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center