Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006
    Posts
    3

    Unanswered: Too many processes

    We have a database purchased from an external company which we have now been running for around 2 years. Following a recent upgrade to the front end we have started receiving the error message "Too many processes open" in oracle enterprise manager.

    What we think is happening is the new upgrade opens a new process each time you perform a query and fails to close the old one. We Have reported this to the supplier and are awaiting a fix.

    As a temporary measure is there any way to increase the max number of processes that may run at any one time or is it a licencing issue? We have had the oracle training but not had much use out of it yet, this didnt seem to be covered in the training.

    Thanks for any help

    Ian

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking



    You could modify the PROCESSES parameter in the init{sid}.ora, which specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.



    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Nov 2006
    Posts
    3

    Thanks

    Thanks

    I managed to change it and it seems to have fixed the problem for now. We have raised an urgent call about the s/w that is causing the problem.

    Ian

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    You need to monitor the connection pool settings on your application side. That is what is controlling the amount of connections. A common problem is either incorrect connection-pool settings or some configuration that does not limit the pool (ie: reuse or close connections)

    Granted, your processes parameter in oracle should be set appropriately as well
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Nov 2006
    Posts
    3
    The problem looks to be the application is opening a process each time it sends a new query and not closing them afterwards untill the user shuts down the app completly. When we had the initial problem we had users with 6 or 7 open and inactive processes, it dosent take many users to max out 150 processes.

    We have a temp fix where we have asked users to log off regularly and have doubled the max processes, the system seemed to be running fine yesterday. We are waiting for the software vendor to fix the problem.

    Thanks for the help

    Ian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •