RE: Configure SDU and TDU parameters to improve Performance
- From: Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Apr 2004 17:40:26 -0400
Where can I get Adams scripts?
Thanks
Muqthar
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Duret, Kathy
Sent: Thursday, April 29, 2004 5:23 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Configure SDU and TDU parameters to improve Performance
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..
Regards,
Kathy Duret
Muqthar,
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: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
* * * * * * * *
*
The information contained in this E-mail message is privileged, confidential,
and may be protected from disclosure; please be aware that any other use,
printing,copying,
disclosure or dissemination of this communication may be subject to legal
restriction or sanction. If you think that you have received this E-mail
message in error, please
reply to the sender and delete it from your computer. Thank you.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
