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: 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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Messing with SDU/TDU in listener.ora
And a max trace on the client should also show the maximum SDU size used as well, via the trace assistant. It's been awhile since I've used it... :) Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 4:52 PM To: Multiple recipients of list ORACLE-L Subject: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Messing with SDU/TDU in 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 Rich, You can determine if a name is being resolved in Oracle Names by turning tracing on, and checking the log files. in names.ora: NAMES.TRACE_LEVEL = 6 This is the minumum level that will show Onames hits/misses From the trace file: This is a miss, and was resolved by tnsnames.ora nngtgma_get_msg_asn: incoming message, 60 bytes long nnocget_get_node: missed testingdb in the cache, ancestor is nngtpma_put_msg_asn: entry This is a hit: nngtgma_get_msg_asn: incoming message, 55 bytes long nnocget_get_node: found dal3 in the cache nngtpma_put_msg_asn: entry With names caching enabled, this is a cache miss, but a hit for Onames. The name was then added to the cache: nngtgma_get_msg_asn: incoming message, 177 bytes long nnocget_get_node: missed VDRP in the cache, ancestor is nnocget_get_node: created VDRP on lookup in the cache nnocget_get_node: found a.smd in the cache nnocget_get_node: found [root] in the cache Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2002 02:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).