This discussion is archived
4 Replies Latest reply: May 16, 2012 1:22 AM by P.Forstmann RSS

tuning parameter to cater number of users

User347578 Newbie
Currently Being Moderated
Hi Folks,


I am in a set up of the new database where i need to set the tuning parameter to cater/serve 2000 concurrent users.

what could be the tuning parameter's that i need to setup .

database connection pool size = ?


max process= ?


also do we need to have a down time for this operation?

any suggestion is highly apprciated .

we have oracle 11g database on linux environment .


Thanks in advance .

Edited by: 790072 on 15/05/2012 18:53
  • 1. Re: tuning parameter to cater number of users
    sb92075 Guru
    Currently Being Moderated
    790072 wrote:
    Hi Folks,


    I am in a set up of the nes database where i need to set the tuning parameter to cater/serve 2000 concurrent users.

    what could be the tuning parameter's that i need to setup .

    database connection pool size = ?
    answer is based upon application implementation & configuration.

    >
    >
    max process= ?
    answer need to be greater than answer to question above

    My seat of the pants SWAG would be start out at 500.
  • 2. Re: tuning parameter to cater number of users
    User347578 Newbie
    Currently Being Moderated
    Hi Thanks for the quick reply ,


    what could be the configuration parameters for this ?


    say for example if i give the parameter

    max process= 2000

    and database connection pool size = 2000


    will this going to serve 2000 concurrent users?
  • 3. Re: tuning parameter to cater number of users
    sb92075 Guru
    Currently Being Moderated
    790072 wrote:
    Hi Thanks for the quick reply ,


    what could be the configuration parameters for this ?


    say for example if i give the parameter

    max process= 2000

    and database connection pool size = 2000


    will this going to serve 2000 concurrent users?
    What about background server session?
    What about application batch jobs?
    It appears you have little real world experience with connection pooling & OLTP environments.
    While there might be 2000 "concurrent" users, there rarely or NEVER will be 2000 concurrent SQL.
    Most of the time while a user is in front of a keyboard, the session & keyboard are 100% IDLE!
  • 4. Re: tuning parameter to cater number of users
    P.Forstmann Guru
    Currently Being Moderated
    Please read following Oracle Magazine article about connection pools http://www.oracle.com/technetwork/issue-archive/2012/12-may/o32asktom-1578049.html. The right settings for number of sessions depends also on the number of CPU cores for machine hosting database instance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points