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!

ORA-00018.Maximum number of sessions exceed

MaahjoorNov 25 2012 — edited Nov 25 2012

Dear all,

i have a windows 2003 server, oracle 10g release 2.
300 concurent users login.

my SESSIONS parameter =800
my PROCESSES parameter=723.

after 2 days or 3 days, i got the follwing message when i try to connect.

ORA-00018.Maximum number of sessions exceed.

even i restart my server, i sometime got this number.

what is the problem? i am realy in very bad situation, users cannot connected,

thanks

This post has been answered by Girish Sharma on Nov 25 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2012

Added on Nov 25 2012

#general-database-discussions

10 comments

78,022 views