user560883 wrote:Did you set the parameter resource_limit=true ? You must do it before you test sessions_per_user. You can do so like the following,
DB Version Oracle Database 11g Enterprise Edition Release 126.96.36.199.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
After this again try and post the feedback.
alter system set resource_limit=true;