RE: listener.ora params required ?

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Tue, 18 Jul 2000 14:20:35 -0700
Message-Id: <10562.112329@fatcity.com>

enough food for thought .. ahh .. here i come metal link :-))

-----Original Message-----
From: Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com] Sent: Tuesday, July 18, 2000 1:14 PM
To: Multiple recipients of list ORACLE-L Subject: Re: listener.ora params required ?

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.

1. Configure the listener with prespawned processes to minimize the connect time for incoming connections. Also, increase the size of the listener queue.
2. 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.
3. 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.
4. Consider setting the TCP.NODELAY option. Check your platform specific documentation for configuration details.
5. 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! http://mail.yahoo.com/

-- 
Author: Gaja Krishna Vaidyanatha
  INET: gajav_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Tue Jul 18 2000 - 16:20:35 CDT