Received: (qmail 11516 invoked from network); 2 Jul 2010 11:38:13 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 2 Jul 2010 11:37:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 07FC6D1A674; Fri, 2 Jul 2010 12:37:52 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id NuxSTfT1XBOy; Fri, 2 Jul 2010 12:37:51 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49BB3D1A67E; Fri, 2 Jul 2010 12:37:09 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Jul 2010 12:36:27 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C0C8AD1A5A4 for ; Fri, 2 Jul 2010 12:36:27 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id hR-b9QZu06dO for ; Fri, 2 Jul 2010 12:36:27 -0400 (EDT) Received: from mail-iw0-f179.google.com (mail-iw0-f179.google.com [209.85.214.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6CFCED17ECA for ; Fri, 2 Jul 2010 12:36:27 -0400 (EDT) Received: by iwn39 with SMTP id 39so1118065iwn.10 for ; Fri, 02 Jul 2010 09:36:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=Hbt7ffkUh6TRUG89z9hp+YjDreKcZ0GEJC9mQ9Yx74Q=; b=SPgrk9z/ZbkzJOFBVmG7Gb1W3qzGDE9X3ZW7iZCwPkpvB83g78MvfX5fvDLZaj2AtM FIc4wdiqifWttxDDro3GbmOlwt2dOoY4Ajj+23mNyKXvPmlGMO+5xwpEGpIby4mdz3OR EewEHRrHesiOfwLFoX7HLjzmCe3+RtnR8t3Y8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=aOSjjE2XjITIASgE8wr3T3V7s79EGtBwK1OpmmC68eZ6Or88A8q0bvcOsCQ3Y32V6q C1QAc3BqfWq4OT6iPJlBHIR9ketkJPZgoYRIcTft2xyRIJ5TxB+xN1wuST6BqSq7L3So vbPB+xp0x//zpBlChSa6o3KFTkxtRm7H/osaI= MIME-Version: 1.0 Received: by 10.231.170.79 with SMTP id c15mr507129ibz.82.1278088586213; Fri, 02 Jul 2010 09:36:26 -0700 (PDT) Received: by 10.231.14.137 with HTTP; Fri, 2 Jul 2010 09:36:26 -0700 (PDT) In-Reply-To: <201007021632.o62GW5pv020933@smtp14.singnet.com.sg> References: <201007021632.o62GW5pv020933@smtp14.singnet.com.sg> Date: Fri, 2 Jul 2010 11:36:26 -0500 Message-ID: Subject: Re: Monitoring software From: Andrew Kerber To: hkchital@singnet.com.sg Cc: sbecker6925@gmail.com, david.robillard@gmail.com, Martin Bach , oracle-l@freelists.org Content-Type: multipart/alternative; boundary=0016e68f9dae2c4500048a6a3006 X-archive-position: 29436 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: andrew.kerber@gmail.com Precedence: normal Reply-To: andrew.kerber@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --0016e68f9dae2c4500048a6a3006 Content-Type: text/plain; charset=ISO-8859-1 I once ran into a problem where the 'developers' simply didn't know how to tune their SQL. They were all java programmers, and were just using the very poor SQL generated from their Java code generator. I couldn't help them much with that, but I could sure find the crappy SQL code. My suggestion was to get developers with some intelligence, but that didn't fly, they were cheap, and worth what they were paid. On Fri, Jul 2, 2010 at 11:32 AM, Hemant K Chitale wrote: > > "What do you people do ... ? " > > Feel very frustrated. > > Note that if you provide weekly reports to the VP , after a few weeks he > might just stop reading them. He wouldn't have the time or want to go > through SQLs and Trace/Tkprof and Statistics. He might or might not expect > the developers to work with you on this. Furthermore, unless the *users* > raise an issue (log a problem ticket), "Performance" in an operating > (production) environment may not get priority. > So you might want to talk to users occassionally and find out where it is > that they find issues. Focus on the user's performance issues. > > Hemant K Chitale > > > At 12:18 AM Saturday, Sandra Becker wrote: > > So what do you people do when you've provided either the information >> and/or tool for developers to see the performance of their code and they >> refuse to look at it and insist it is up to the DBAs to tune it and make it >> efficient? I also provide performance information to my VP on a weekly >> basis and all other high level execs on a quarterly basis but no one except >> my VP seems to take it seriously. That's the boat I'm in right now and it >> seems to have a really big hole that is leaking more day by day. >> >> >> -- >> Sandy >> Transzap, Inc. >> > > > Hemant K Chitale > > http://hemantoracledba.blogspot.com > > > > > > -- > http://www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' --0016e68f9dae2c4500048a6a3006 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I once ran into a problem where the 'developers' simply didn't = know how to tune their SQL.=A0 They were all java programmers, and were jus= t using the very poor SQL generated from their Java code generator.=A0 I co= uldn't help them much with that, but I could sure find the crappy SQL c= ode.=A0=A0 My suggestion was to get developers with some intelligence, but = that didn't fly, they were cheap, and worth what they were paid.

On Fri, Jul 2, 2010 at 11:32 AM, Hemant K Ch= itale <hkch= ital@singnet.com.sg> wrote:

"What do you people do ... ? "

Feel very frustrated.

Note that if you provide weekly reports to the VP , after a few weeks he mi= ght just stop reading them. =A0He wouldn't have the time or want to go = through SQLs and Trace/Tkprof and Statistics. =A0He might or might not expe= ct the developers to work with you on this. =A0 =A0Furthermore, unless the = *users* raise an issue (log a problem ticket), "Performance" =A0i= n an operating (production) environment may not get priority.
So you might want to talk to users occassionally and find out where it is t= hat they find issues. =A0Focus on the user's performance issues.

Hemant K Chitale


At 12:18 AM Saturday, Sandra Becker wrote:

So what do you people do when you've provided either the information an= d/or tool for developers to see the performance of their code and they refu= se to look at it and insist it is up to the DBAs to tune it and make it eff= icient? =A0 I also provide performance information to my VP on a weekly bas= is and all other high level execs on a quarterly basis but no one except my= VP seems to take it seriously. =A0That's the boat I'm in right now= and it seems to have a really big hole that is leaking more day by day.

--
Sandy
Transzap, Inc.


Hemant K Chitale

http://he= mantoracledba.blogspot.com





--
htt= p://www.freelists.org/webpage/oracle-l





--
Andrew W. Kerber=

'If at first you dont succeed, dont take up skydiving.'
--0016e68f9dae2c4500048a6a3006-- -- http://www.freelists.org/webpage/oracle-l