setting # of processes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: setting # of processes

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Wink

    How do I determine/calculate the right number of processes that I should set in my initSID.ora parameter?

  2. #2
    Join Date
    Feb 2000
    Posts
    175

    Angry

    Hi,

    The Processes parameter specifies the maximum number of O/S user processes that can simultaneously connect to the database. This includes all the background processes. Therefore the processes parameter should be the sum of the maximum number of users and the number of background processes running.

    Cheers
    Moff.

  3. #3
    Join Date
    Jan 2001
    Posts
    318
    Each user can have more than one connection, process. So it cannnot be max users + system processes.
    What do you think ?
    Sonali

  4. #4
    Join Date
    Dec 2001
    Location
    bangalore
    Posts
    1

    Smile

    identify average number of connections that shall be open by your application (if client-server) and multiply the number of users and add the number of background process.

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