Database Administration (MOSC)

MOSC Banner

What is "IDLE TIME" will applied if a user was assigned to both a Profile and a Consumer Group?

Hello,

What is "Idle Time" applied to a user if this user was assigned both of Profile and Resource consumer group ?

Query from DBA_USERS:

  • User_A assigned to Profile "ProfileUsers" with IDLE_TIME = 15 (15 minutes)

Query from V$SESSION:

  • User_A accessed to database
  • User_A belong to Resource Consumer Group "USER_CG"
  • "USER_CG" belong to PLAN "IDLE_TIME_15_MIN" with MAX_IDLE_TIME=900 (15 minutes)

I used below script to check

SELECT  ssn.username,  u.profile,  ssn.resource_consumer_group,  u.initial_rsrc_consumer_group

FROM  v$session ssn  inner join dba_users u

on ssn.user# = u.user_id

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