DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: processes

  1. #1
    Join Date
    Jul 2001
    Posts
    40

    Thumbs up

    Hi

    I've increased the number of process from 50 to 200 to 350 to 500. This is I'm doing when I receive a 'Number of process exeeded error'. I feel I can't keep on increasing in this manner.

    How to solve it permenantly? I found lot of sessions are inactive and they are not getting vanished for long time?

    If in an application let us take 1000 Concurrent users are connecting, what should be the value of process parameter? Or is it advisable to configure the database in MTS?

    Could any expertise throw some light on it?

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    I would consider using MTS, especially if you expect the amount of users to increase. MTS is excellent for scalability and helps make better use of resources.

    Just because sessions are inactive, it doesn't mean that the user has logged out, it simply means that a user is in an idle state, not requesting any processing.

    Here is some info on managing Oracle processes.

    http://otn.oracle.com/docs/products/...proc.htm#12007
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you have 1000 users connecting (with dedicated servers), you need at least 1000 processes.
    Jeff Hunter

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