Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No of Concurrent Sessions Per User Mismatch with profile settings

saam001Jul 4 2010 — edited Jul 4 2010

Hi

DB Version Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
OS RHES 5U2

I created a profile MYPROFILE and set the value of Concurrent Sessions (Per User) to 30. DB was bounced after creating the profile. I made this profile default for a particular user "MYUSER". I verified that by querying DBA_USERS (select profile from dba_users where username like 'MYUSER') I checked v$session with that particular user after sometime and noticed that it was showing 34 sessions. Some ACTIVE and some INACTIVE.

My question is, if I have set the maximum limit of concurrent sessions per user to 30 in myprofile and made this the default profile for MYUSER, then how come i am still able to see more than 34 sessions of myuser regardless of the status? I am not sure if this is relevant or not but the IDLE TIME is set to 15 minutes.

Thank you for your help

Edited by: user560883 on Jul 4, 2010 12:45 AM

This post has been answered by Aman.... on Jul 4 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2010

Added on Jul 4 2010

#general-database-discussions

8 comments

5,540 views