Maximum Processes Reached error
VPSFeb 26 2007 — edited Mar 21 2007Friends,
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