-
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.
Sanjay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|