RE: Database performance monitoring tool for developers.

The "Wall of Shame" idea is cute, similar to a program I started in a group I was in a few years ago.

We had a bunch of contractors and duhvelopers running amok, so as one of the development managers, I went to another and suggested that we institute a program of mandatory code reviews. I initially expected the usual "buddy" system where another developer would be corralled into reviewing the code and sign off on it. We were also hiring a core team of developers to replace the least effective folks already on board.

The other manager decided to do it somewhat differently; he set up a regular meeting in which all developers who had code to review would present their code, and a panel/peanut gallery, who would have access to the code in advance, would comment/take pot-shots.

It was _painful_ the first few weeks. Had to jump between a couple of near fist-fights. However, within a month the group was putting out some of the best code I've ever seen. The duhvelopers either got up to speed or were let go, and the effeciency and effectiveness went through the roof.

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
> Sent: Thursday, April 17, 2003 10:17 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Database performance monitoring tool for developers.
>
>
> works both ways. If I do something really stupid, I'm usually
> the first to tell people about it. But if I don't, then yea,
> I should have my name up there too.
>
> How about a generic "Wall of Shame"?
> --- "Spears, Brian" <BSpears_at_Limitedbrands.com> wrote:
> >
> > #4 could work if its done in the spirit of fun but... Just think of
> > the DBA wall of shame... wouldn't that be fun. I like the
> coming from
> > the other
> > direction... tend reward to the improving stats about bad
> > code/problem...
> >
> >
> > Brian
> >
> > -----Original Message-----
> > Sent: Wednesday, April 16, 2003 10:14 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I vote for #4!
> >
> > --- Cary Millsap <cary.millsap_at_hotsos.com> wrote:
> > > My $0.02...
> > >
> > > Developers usually don't have access to a high-concurrency test
> > > environment in which an expensive monitoring tool would make that
> > > much
> > difference
> > > anyway. The most powerful tools I've seen?
> > >
> > > 1. Performance specifications - Functional specs contain
> a budgeted
> > > number of LIO operations that the code is allowed to
> consume. A good
> > > rule
> > of
> > > thumb
> > > is 10 LIOs per (non-aggregated) result set row per table. For
> > > example, a 4-way join returning one row gets a budget of no more
> > > than 40 LIOs.
> > >
> > > 2. Profiling (tkprof, autotrace, etc.) - EVERY piece of code gets
> > > traced and run through a profiler. If a piece of code breaks its
> > > specified LIO budget,
> > > then it's not approved for check-in.
> > >
> > > 3. Execution plan analysis (explain plan) - EVERY piece
> of code has
> > > its execution plan checked by a performance analyst.
> Execution plans
> > are
> > > generated with PRODUCTION db statistics, not test db statistics.
> > >
> > > 4. The Wall of Shame - Write inefficient code, and your code goes
> > up
> > > on the
> > > Wall for everybody to see. People whose names appear
> continually on
> > > the Wall of Shame are not selected as candidates for reproduction.
> > >
> > > Who is the referee in all this? The performance analyst. Some
> > > performance analysts are DBAs, some are developers, some are
> > > architects, and
> > some
> > > are
> > > none of the above. It doesn't matter who takes on the
> role, as long
> > > as it's someone competent and credible.
> > >
> > >
> > > Cary Millsap
> > > Hotsos Enterprises, Ltd.
> > > http://www.hotsos.com
> > >
> > > Upcoming events:
> > > - Hotsos Clinic 101 in London, Reykjavik, Ottawa, Dallas, Denver,
> > > Sydney
> > > - Visit www.hotsos.com for schedule details...
> > > - IOUG-A Live 2003, Orlando, 10am Monday 28 April: "Oracle
> > > Operational Timing Data"
> > >
> > > -----Original Message-----
> > > Faroult
> > > Sent: Wednesday, April 16, 2003 3:24 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > > "Grabowy, Chris" wrote:
> > > >
> > > > Yes, they are teaching you what to look for...
> > > >
> > > > > 1) Dictionary Cache Hits (ARGH!!!!!!!!!!!!!!!!!)
> > > > > 2) Percentage of Current Processes (as in we have 30
> processes
> > > > > attached and 300 processes configured in the init.ora)
> > > > > 3) Sessions Waiting for Lock
> > > > > 4) Total Sort Rate (rate of sorts per minute) on disk and in
> > > memory)
> > > >
> > > > ;)
> > > >
> > > > And in my dealings with account execs, to close a deal, the
> > hosting
> > > AE
> > > > will make sure the client gets whatever reports they want...
> > > >
> > > > Can I go back into my corner now?
> > > >
> > > > -----Original Message-----
> > > > Sent: Wednesday, April 16, 2003 11:29 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > > it should be the hosting company's job to teach the clients what
> > to
> > > > really be looking at.
> > > >
> > > > --- "Grabowy, Chris" <cgrabowy_at_fcg.com> wrote:
> > > > > (stumbling out of my lurker corner)
> > > > >
> > > > > Is it possible that some clients expect to see those cache hit
> > > ratio
> > > > > reports? Arent there still quite a few Oracle sites that are
> > > still
> > > > > hung up on RBO and cache hit ratios??
> > > > >
> > > > > -----Original Message-----
> > > > > Sent: Wednesday, April 16, 2003 9:44 AM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > >
> > > > >
> > > > > Ah but see, I didn't say 'DBA privs'. Most of the tools can be
> > > used by
> > > > > an account that has select only on any of the v$ or
> dba_ views.
> > > > >
> > > > > I also said "database aware". Which means they understand what
> > > the
> > > > > results mean.
> > > > >
> > > > > And then there are things like....
> > > > >
> > > > > the hosting company we use has reports on performance
> etc that
> > > > > authorized users can look at. Reports are on CPU, Webservers,
> > > page
> > > > > downloads and Oracle. Here's the sad part. There are 4 Oracle
> > > > > reports:
> > > > >
> > > > > 1) Dictionary Cache Hits (ARGH!!!!!!!!!!!!!!!!!)
> > > > > 2) Percentage of Current Processes (as in we have 30
> processes
> > > > > attached and 300 processes configured in the init.ora)
> > > > > 3) Sessions Waiting for Lock
> > > > > 4) Total Sort Rate (rate of sorts per minute) on disk and in
> > > memory)
> > > > >
> > > > > NONE of these are really useful, as they are reported on a
> > daily
> > > > > basis.
> > > > >
> > > > >
> > > > > The first we know is really useless, and one of these days I'm
> > > going
> > > > > to install a cron job to run Connor's BCHR script, just for
> > > giggles.
> > > > >
> > > > > The percentage of current processes makes no sense to
> me, as we
> > > run
> > > > > with connection pooling.
> > > > >
> > > > > Sessions waiting for Lock on a daily basis? I suppose it could
> > be
> > > > > useful, if only to point me to an app to start tuning.
> > > > >
> > > > > And what really worries me is that the Sort Rate report is the
> > > "most
> > > > > popular" (most viewed) of all of them. Not by me, I just
> > learned
> > > about
> > > > > these reports yesterday.
> > > > >
> > > > > I need to have a LONG talk with the hosting company.
> > > > >
> > > > >
> > > > > --- April Wells <awells_at_csedge.com> wrote:
> > > > > >
> > > > > > I will go along with that.
> > > > > > Whole heartedly in fact
> > > > > > But with a disclaimer.
> > > > > > They (the users with access to the tools) have to be willing
> > to
> > > > > learn
> > > > > > the
> > > > > > tool, and what the results MEAN. If they are willing to
> > learn
> > > > > > (really learn, not just hear part then think they know all
> > > there is
> > > > > > to know about
> > > > > > tuning code), I will give them access to the tools in a min.
> > > > > >
> > > > > > We have one developer who I trust implicitly. She wants to
> > > learn,
> > > > > > tries to use good coding standards and tries to write the
> > > tightest
> > > > > > code possible. I
> > > > > > would give her DBA privs on the development instance in a
> > > > > heartbeat,
> > > > > > and any
> > > > > > tool at my disposal to help her do her job.
> > > > > >
> >
> === message truncated ===
>
>
> __________________________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo http://search.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).