Reasonable number of 'users' per listener for good performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Reasonable number of 'users' per listener for good performance

  1. #1
    Join Date
    Jan 2001
    Posts
    3
    We have an application that will have thousands of clients hitting a particular Oracle 8.16 instance on a AIX box.

    For optimal performance, what is the reasonable maximum number of users per listener. Or, at what point do I configure additional listeners?

    Thanks.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Instead of configuring multiple listeners, I would suggest that you configure the listener to listen on multiple ports. and set the load balancing on your tnsnames.ora file to do the loadbalancing.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by MaryJoH
    Or, at what point do I configure additional listeners?
    Only when a large number of users are trying to connect to the database at the same time. Once the session is established between the client and the database, the listener is not involved in their communication any more. The only role the listener is playing is during initial part of the session, during logon. Once the session is established listenr's work is finished.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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