Many processes than I expect
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Many processes than I expect

  1. #1
    Join Date
    Jul 2002
    Posts
    2

    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.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    You have to increase the processes parameter. What is your current processes setting ? What is your OS ?

  3. #3
    Join Date
    Jul 2002
    Posts
    2

    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?

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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
  •  


Click Here to Expand Forum to Full Width