Database Administration (MOSC)

MOSC Banner

Using Resource Manager question

edited Sep 26, 2017 5:01AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi I have created a resource manager group.

This is one of the plan directives I have in place and I have it in place because I understand it is mandatory.

dbms_resource_manager.create_plan_directive(

      plan=> 'USF_ORACLE_COM_PLAN',

      group_or_subplan => 'OTHER_GROUPS',

      comment => 'The mandatory group',

      mgmt_p1 =>50);

I am assigning users to other plan directives.   My question is:  For all users that are not explicitly assigned to other directives, do they automatically get assigned implicitly to the 'Other Groups' plan directive?   Is this an all or nothing deal?   As I'm understanding is that once you enable Resource manager that all users in the database get assigned to the resource group and that is why an 'other groups' has to get defined.   Am I understanding this correctly?  Please advise.

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