8 Replies Latest reply on Jul 4, 2010 8:29 AM by Aman....

    No of Concurrent Sessions Per User  Mismatch with profile settings


      DB Version Oracle Database 11g Enterprise Edition Release - 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