Skip to Main Content
Forums

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!

SESSIONS_PER_USER limit value = DEFAULT, what the default signifies here?

Green DustSep 28 2017 — edited Sep 28 2017

DB Version : 11.2.0.4

OS : Solaris 5.10

What does the SESSIONS_PER_USER limit value = DEFAULT?, how many connections will be allowed per user?, I am aware that, if the limit is UNMILITED then no limit. not sure with the DEFAULT value behavior?. any inputs please.

SQL> select limit from dba_profiles where profile='APPL_PROFILE' and resource_name='SESSIONS_PER_USER'

LIMIT                                  

----------------------------------------

DEFAULT    

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2017
Added on Sep 28 2017
#general-database-discussions
3 comments
9,361 views