number of precesses keeps increasing
Hi all,
I have a production database on oracle 10gR2. The version is 10.2.0.1. I have 6 application servers connected to a single instance. the application server i am using is weblogic and glass fish. the database is running on sun solaris sparc.
The problem i am facing is that the number of process keeps increasing. Now i have increase my processes to 5000. If it increases beyond this number my database crashes?
can anyone provide a solution?
After doing much reasearch i have come to the conclusion, RAC is the solution instead of increasing the capacity of hardware. Presently i have a V890 server with 32GB RAM, 10Gb SGA and 2 CPU board with dual core of 1.5 GHz each.
I have a production database on oracle 10gR2. The version is 10.2.0.1. I have 6 application servers connected to a single instance. the application server i am using is weblogic and glass fish. the database is running on sun solaris sparc.
The problem i am facing is that the number of process keeps increasing. Now i have increase my processes to 5000. If it increases beyond this number my database crashes?
can anyone provide a solution?
After doing much reasearch i have come to the conclusion, RAC is the solution instead of increasing the capacity of hardware. Presently i have a V890 server with 32GB RAM, 10Gb SGA and 2 CPU board with dual core of 1.5 GHz each.
0