RE: SQL *Net more data from client - waiting too long

Typically as a dba I don't have time to debug much on the application side, if you have the time that's great, but the best I usually have time for is to track down poorly performing sql, and even then I often cant do much more than identify it. In any case, most apps we have here are 3rd party software that we don't have the ability to change, so its just not a good use of my time to try and diagnose problems with outside applications.  

Andrew W. Kerber
Oracle DBA
UMB     "If at first you dont succeed, dont take up skydiving"

-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Tuesday, January 09, 2007 12:55 PM To: Kerber, Andrew
Cc: dd.yakkali_at_gmail.com; oracle-l_at_freelists.org Subject: Re: SQL *Net more data from client - waiting too long  

On 1/9/07, Kerber, Andrew <Andrew.Kerber_at_umb.com> wrote:

        It also means its not a problem w/ Oracle, it's a problem with the application.

Absolutely not picking on Andrew here, since this and some of the implications are a common view, but am I the only one to think that the distinction is somewhat false. Technically a bad app is not my problem as a DBA, but professionally and in reality I view it as my problem to diagnose, report and offer solution with applications. In other words I see application level design and performance problems as part of my purview. What do others think?

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info 


------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================


--
http://www.freelists.org/webpage/oracle-l