Skip to Main Content

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!

Maximum Processes Reached error

VPSFeb 26 2007 — edited Mar 21 2007
Friends,

I was connecting the database using vb application to check how many users are in the sessions.
i was regularly watching this without any problem for the past 6 months.
Suddenly today, when i executed the vb program.
i received an error "Maximum processes reached...." Maximum users connecting to our database at an average is 150-160. still now i have seen maximum of 140 in the sessions including oracle sessions.

RHEL AS 3.0
Oracle 9iR2 (9.2.0.4.0)

Then i checked the following...

SQL> show parameter processes;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
db_writer_processes integer 1
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150
SQL>

SQL> select count(*) from v$process;

COUNT(*)
----------
136

SQL>

in the init.ora file....


###########################################
# Processes and Sessions
###########################################
processes=250


so, am i have to change any setting to avoid such an error? if yes, please suggest me.

Thanks & Regards
Sathyguy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2007
Added on Feb 26 2007
17 comments
4,269 views