Database Tuning (MOSC)

MOSC Banner

Resource Manager

edited Jun 7, 2010 5:03PM in Database Tuning (MOSC) 5 commentsAnswered
 Hello, I am using the resource manager and i have associated some users to particular groups.
for example, using the "consumer group mapping" of the grid, i have set my account to the group "low"

When i connect to the db, i can see that i am associated to the group "OTHER_GROUPS" instead of "LOW_GROUP"

SELECT
     resource_consumer_group
    ,username
  FROM v$session
 WHERE resource_consumer_group IS NOT NULL
 ORDER BY resource_consumer_group, username
;

I do see what's wrong, is the server not load enough to dispatch users is their own group ?

thanks

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