sessions

Posted by big on May 06, 2022; 6:49pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/sessions-tp10889.html

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.