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?
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.
Life is a journey, not a destination!
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.
Originally posted by MaryJoH
Or, at what point do I configure additional listeners?
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width