| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow ODBC connectivity
Rich
Great story! But it made me realize that I wasn't even thinking about ODBC tracing. To clarify, I was thinking about Oracle tracing, specifically the 10046 trace that has often been discussed on this list. But it is nice to have an additional type of tracing (ODBC) at your disposal. My analogy is that when it comes to tuning it is always better to have another tool in your toolbox.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
Sent: Thursday, February 05, 2004 9:32 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Slow ODBC connectivity
Hey, good point! When we had some ODBC performance problems a few years ago, I attempted to turn on ODBC tracing but it was already on. Turned it off and deleted the 100s of MB of ODBC trace and all was well. :)
Rich
Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: Thursday, February 05, 2004 9:12 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Slow ODBC connectivity
Patrice
Since it sounds like an in-house application, you might have the developers insert a statement to turn tracing on. Review of the trace might give you an idea of where the delays occur. From your posting, it sounds like you are assuming ODBC is the culprit, yet you also mention that you found one SQL statement that is causing significant delay itself. The question is whether the delay is due to ODBC or due to the SQL statements. Sometimes problems occur just due to the amount of network traffic back and forth between the server and the client. I think this question must be resolved before you decide on a tuning plan. A detailed trace should reveal the answer to this question. As Cary Millsap says in his book, this may be a situation where the SQL wait times are significant and can't be treated as inconsequential. Good luck, these types of situations can require a lot of time and patience to unravel.
Dennis Williams
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |