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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Tuning Question

Re: Oracle Tuning Question

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 22 Aug 2003 11:01:48 -0700
Message-ID: <1a75df45.0308221001.1b9bd62f@posting.google.com>


rc@(no-spam)bhfshops.org.uk

> >First off, is there a performance problem? Have you identified it? Or
> >are you imagining there might performance problems and planning to
> >take pot shots in the dark in the hope of hitting something?
>
> Pot shots in the dark and hit something, thats why I am asking how do
> I monitor this ?

Why waste your time doing that? Rather spend that time surfing www.wickedweasel.com <wry grin>

Simple fact. You cannot solve a problem if you don't know what it is.

Also applies to performance tuning. You have to identify the performance problem in order to fix it.

Thus, if your hit ratios are low, then bigger buffer caches may do. Maybe there's a lookup table that is very often used, but due to circumstance/config do not live in buffer cache - in which case you can consider caching that table manually. Maybe there's a job opening for a bitmap index. Or PCTFREE is set to zero and the table heavily updated. Or they do not using bind variables, which means loads of hard parses which could be addressed with forced cursor sharing. Etc. Etc.

There a myriad of tuning posibilities. Trying them one at a time in order to see what happens... well, that's will be a real waste of time.

So, first _meassure_ the performance. Identify problem areas. Then go about trying to address them.

--
Billy
Received on Fri Aug 22 2003 - 13:01:48 CDT

Original text of this message

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