Vivek,
I currently don't have the time to give all the details but here
are some things that I would look out for tuning the listener
and the networked environment. Please check out the
documentation for configuration details.
- Configure the listener with prespawned processes to minimize
the connect time for incoming connections. Also, increase the
size of the listener queue.
- Consider the use of the multi-threaded server if the
connections do "sporadic work" and are NOT "power users". This
facilitates multi-threading on the Oracle Server side.
- Consider using the Connection Manager functionality to while
using Oracle's MTS configuration. This facilitates
multi-threading network connections of Oracle sessions.
Connection Pooling/Multi-plexing etc. is not applicable for
dedicated server connections.
- Consider setting the TCP.NODELAY option. Check your platform
specific documentation for configuration details.
- Set the SDU buffersize for more optimal network
transmission.
Best Regards,
Gaja.
- VIVEK_SHARMA <vivek_sharma_at_inf.com> wrote:
>
> What listener.ora params Advisable for Optimal performance ?
>
> Approx. 500 Unix users Currently logging into the App server
> which will grow
>
> very soon to 1500 Users . ( Connecting to DB Server VIA
> SQL*NET )
>
> DB Server E6500 model of SUN - 21 GB Database Currently which
> will grow to a
> few Hundred GB very soon , 26 CPUs , 20 GB RAM
>
> APP Server E6500 model of SUN - 20 GB RAM , 26 CPUs
>
> SunOS 5.6 on Oracle 7.3.4
>
>
Gaja Krishna Vaidyanatha
Director, I-O Management Products
Quest Software Inc.
(972)-304-1170
gajav_at_yahoo.com
"Opinions and views expressed are my own and not of Quest"
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
Received on Tue Jul 18 2000 - 14:05:41 CDT
