sessions

[big]

Hi,

On 11.2.0.4 on AIX

If for a profile we have

RESOURCE_NAME          LIMIT                  
------------------------------- ---------------------------------------        
SESSIONS_PER_USER       20  

This number of session is included and should be less than :

SQL> show parameter sessions
NAME                 TYPE    VALUE
------------------------------- ---------------------------------------        
sessions               integer   800

In other words total SESSIONS_PER_USER for all users should be less than sessions parameter (800)?

Thanks.

[ErmanArslansOracleBlog]

They are different things.
session_per_user is the limit for the number of concurrent sessions that belong to a DB user.
sessions is the general limit. that is, you can't have more than 800 sessions in your database (if you set the sessions parameters to 800)

Some background info (Ref Oracle:)

SESSIONS specifies the maximum number of sessions that can be created in the system. Because every login requires a session, this parameter effectively determines the maximum number of concurrent users in the system. You should always set this parameter explicitly to a value equivalent to your estimate of the maximum number of concurrent users, plus the number of background processes, plus approximately 10% for recursive sessions.

[big]

Thank you.