Re: Oracle Tuning Question

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