Maximum no. of Process/connection?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Maximum no. of Process/connection?

  1. #1
    Join Date
    Aug 2000
    Posts
    194
    Hello:

    I am using Oracle 8.1.6 on Linux with dedicated server process configuration.

    What are the implications of increasing the number of process from 100 to say 500?

    Before increaing the PROCESSes what should I look for? What are all the side effects on oracle on increasing this value? (ex, any latches, high memory usage etc..)

    Whats the maximum value, I can go upto? (from Oracle perspective and OS perspective).

    The machine has 1G memory. How much memory each connection takes?

    Note: Right now I am not considering MTS.

    Thank u..

  2. #2
    Join Date
    Aug 2000
    Posts
    194
    Note,

    The application uses persistent connection and the connectin will stay as long as the WEB (Apache) server is alive.

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