Re: Tuning Question

You gotta love those tuning tools that are nothing more than glorified expert systems. The biggest problem with these tuning tools is that you wouldn't pay any more for it if it didn't make any suggestions. Therefore, it always makes a suggestion! I once had a tuning tool which told me I had problem A and to perform action A to solve it. So I did. I ran the tuning tool again and it told me I had problem B and to perform action B to solve it. So I did. I ran the tuning tool again and it told me that I had problem A and to perform action A to solve it. Right then and there I knew that tuning tools are structured to always make a suggestion, no matter what.

Personally, I only use two tuning tools: 1) SQL*Plus
2) Oracle Trace Facility

Everything else just clouds the issue.

Cheers,
Brian

Burton Peltier wrote:
>
> Good question... none :)
>
> Anyway, if you missed the original post, I have someone who works with me
> who is asking to make the change. He is running some new monitoring tool (
> some free scripts) and it points at this 1 query (and several others) as
> needing an index.
>
> --
>
> "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
> news:3ef889bd_3_at_mk-nntp-1.news.uk.worldonline.com...
> > "Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message
> > news:FppJa.38266$T37.19170_at_fe05.atl2.webusenet.com...
> > >
> > > I agree and I have been doing that, usually. I didn't think this one
> thru
> > as
> > > I should have.
> > >
> > > Thanks for pointing out the real issue (production change with no
> > testing).
> > >
> > > I will put it back to the other DBA to show me proof of no adverse
> impact
> > > and "some" improvement. Then I will check the results myself.
> > >
> > > Also, he and I need to talk about overall work priorities ! ... It
> just
> > > occurred to me, I cannot believe I almost sound like a manager now -
> > yikes!
> >
> > Just one small question: what performance issues are your users
> > experiencing, which necessitates this tuning?
> >
> > Regards,
> > Paul
> >
> >
> >

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"