What is processes set to in the init.ora file?

===============================
Wayne Scotchmer
Delivery.ca ( www.Delivery.ca )
wayne.[Email Address Removed] flowers and more...
With a click of your mouse...
Delivery to your house!"
===============================
----- Original Message -----
From: Kevin Shao
To: LazyDBA.com Discussion
Sent: Thursday, May 31, 2001 11:30 AM
Subject: Max processes reached - can not log on to the DB


I have application talks to an Oracle db, it opens 50
connection session pool every time. It does not
terminates itself, but be manuelly killed. However,
after the application grabs all the sessions, I can
not even log on to the db, nor other maintnence jobs
are performed.

Please advise: It there any way I can do to receive
several sessions for DBA use only? or what is the best
method to solve such a situation?

Thanks in advance

Kevin


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page