Proesses Limit andOpen Cursors Limit in Oracle 10g in Windows 32 Bit
Posted on 2007-11-27
We have developed business application software using Oracle 10g as the back end and VB as the front end.
When Oracle 10g is installed on Windows 2003 server, it has by default 300 Open Cursors and 150 Processes. There are approx 50-100 simultaneous users working on our software at the Client end.
Software works fully OK for days and months togather. Rarely we get that limit of Processess is exhausted and then it does not allow users to connect where as the number of users at that time may be even smaller than previously. In that case we need to shutdown the Oracle Server and Startup again. The problem gets solved.
Solution is required to permanenlty fix the the problem. Shutting down the Oracle Database and running again is not the soltution.
Noida -UP -India