More processes than I expected
I find that there are many processes on my oracle server just like:
oracle 1617 1 0 Mar 29 ? 0:00 oraclems (LOCAL=NO)
its amount is more than the client connections, and I couldn't connect to my oracle after one day or may be two cause the processes exceed the limit.
what's the possible problem? Thanks for your reply.
You have to increase the processes parameter. What is your current processes setting ? What is your OS ?
The current processes limit is 50 and the OS is HP-UX
My programs commonly have 12 connections to oracle, and I can find exactly 12 sessions in v$session, but there are more than 50 processes in v$process, is it normal?
I suspect there are some process that have not been terminated even after the client session has been terminated.
You can corelate spid (from v$process) to the unix PID.
Click Here to Expand Forum to Full Width