Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL *Net more data from client - waiting too long

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

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 9 Jan 2007 14:26:03 -0500
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B0276346A@jax-mbh-01.jax.crowley.com>


I agree with you Niall, having said that I see what Andrew is saying. This is the second company I have worked for where I am the only DBA. Besides straightening up what I see; to conform to at least my standards, interruptions to the day abound, from the most recent time zone change, to well... if it pertains to databases, then I am defacto involved. So one can find themselves in a position where if you were to start spending time with the app issues, you may spend to much time leaving yourself at risk because some important DBA things did not get set up in time. If you get to many DBA's (like six or so), then some will tend to specialize.  

However Consider coming full circle to what you are saying Niall. When the database is slow, (read app), who is going to be on the job then? Yes you, and at inconvenient times, so just get it over with. Now if Andrew can teach or offload a lot of that tuning, the better... Hmmm, I wonder if I had a opportunity in politics?  

My £0.02 (that's like two cents, but just a little more valuable) :-)  

P.S. In my case I might add, I also have SQL*Server, which I try and ignore :-) -- No, I really do try.

Oracle means 'all knowing'.... SQL server means, well, nothing really.  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Tuesday, January 09, 2007 1: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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 09 2007 - 13:26:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US