Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Messing with SDU/TDU in listener.ora
Turn on sqlnet tracing on a client and see what the sqlnet log says. Here's an example from one of mine. I am using the default SDU/TDU, supposedly.
nsconneg: vsn=310, gbl=0x0, sdu=2048, tdu=32767
-----Original Message-----
Sent: Tuesday, June 11, 2002 5:10 PM
To: Multiple recipients of list ORACLE-L
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:
TIA!
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WIUSA
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).
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). Received on Tue Jun 11 2002 - 16:52:06 CDT
![]() |
![]() |