Re: Diagnose Slow System

I don't get what it means when the oraperf report says the tuning suggestions are "ranked" in order of the potential impact they may have on performance.

It seems like that means the item at the top of the list would have the most potential impact, but the report also has an estimate of the percent improvement you might expect for each suggestion. On one report, the percent for these items (from the top of the list and working down) was: 5%, 30%, 8%. If tuning the first one might only have a 5% impact, why is it at the top of the list?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, May 25, 2002 2:58 PM

> short answer: yes
>
> oraperf is written/run by Anjo Kolk, father of the tuning by wait event
> methodology. I would tend to trust his suggestions for tuning
> opportunities. Would I not also investigate on my own? No. I know my
> apps, he doesn't unless he's come onsite. But oraperf can give me some
> generic guidelines and places to start looking
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).