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