Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Configure SDU and TDU parameters to improve Performance

RE: Configure SDU and TDU parameters to improve Performance

From: Duret, Kathy <>
Date: Thu, 29 Apr 2004 16:22:40 -0500
Message-ID: <>

I agree with Stephen... tried out SDU and TDU with minimal improvement... (on 8.1.7, 9.0 no RAC) when I put my effort back on minimizing the traffic by tuning sql, reducing parsing,etc... the results were much better. Adams scripts helped my out in my efforts..


Kathy Duret


I have done some work with configuring SDU and TDU, but not with RAC. To tune SQL*Net-related waits, you can take one of two approaches (or both):

Approach 1: Make SQL*Net communication more efficient. This can be done the way you are suggesting. In my experience, the time invested in this resulted in a very minor (almost unmeasurable) improvement that might have been caused by other factors. Increasing network bandwidth and similar activities also fall into this category.

Approach 2: Reduce the SQL*Net traffic. For example, if you are parsing a lot, look at cursor sharing and cursor utilization (Steve Adams has some good scripts for this). Reducing parsing will reduce network traffic and make remaining traffic more efficient. Reducing unecessary network traffic would also help this as well.

Good luck.
Stephen Andert


This transmission contains information solely for intended recipient and may be privileged, confidential and/or otherwise protect from disclosure. If you are not the intended recipient, please contact the sender and delete all copies of this transmission. This message and/or the materials contained herein are not an offer to sell, or a solicitation of an offer to buy, any securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not represent that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject to change without notice. Any information you share with us will be used in the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written agreement, we are not agreeing to treat any information confidentially and will use any and all information and reserve the right to publish or disclose any information you share with us.

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Thu Apr 29 2004 - 16:24:51 CDT

Original text of this message