Messing with SDU/TDU in listener.ora

Hey all,

Running the response_time_breakdown.sql from Steve Adams
(http://www.ixora.com.au) on an 8.1.6.0.0 Solaris instance, I'm seeing 40%
of the execution time in "SQL*Net more data from client". I figured that this was due to the clients being sluggish 3rd-party Java apps, but thought I'd check into to it anyway.

One thing I noticed is that the SDU and TDU have been set to 32768 in the listener.ora. First, according to Metalink note 44694.1, this isn't even valid, since the max size is 32767. Second, I know that the Oracle Names entry for this instance does not have either of these set. The tnsnames.ora does, however, and I can't tell which one is being used by the client.

So, before I go ahead and remove these entries from the listener.ora:

1. Is there a way to tell from the server what the SDU/TDU values of a client are? This way I can tell if the Oracle Names entry is being used by the app or if it's using the tnsnames.ora
2. Does 32768 have an effect if it's not in the range of valid numbers for SDU/TDU?
3. Can these parameters affect the "SQL*Net more data from client" wait times?

TIA!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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

also send the HELP command for other information (like subscribing).