Re: Tuning Advice

Is the application using the database binding its variables? (e.g. do you have "WHERE column = value" or "WHERE column = :b1") You can check by looking at V$SQLAREA.

In article <7rr5e6$i4j$1_at_nnrp1.deja.com>,   rspeaker_at_my-deja.com wrote:
> we are currently running Oracle 8.0.4.3.1 on AIX 4.2.1, as a back-end
to
> a Remedy Help Desk installation. I have been reviewing some of the
> Oracle tuning parameters, and have a few questions I was hoping
somebody
> could assist with.
>
> Currently I have 128 MB of physical memory allocated to the
shared_pool.
> I am only seeing hit ratios of 50% - 60% in the SQL AREA of the
library
> cache. The other areas of the library cache, such as TABLE/PROCED,
are
> showing hit ratios of around 99%, as is the Dictionary Cache. This
> leads to me to believe there may be a factor or factors other than the
> shared_pool_size that may need tweaking. My reloads are around 3%.
>
> Also, my logical hitratio (logical reads / (logical reads + physical
> reads)) is running around 88%. Will increasing the shared_pool_area
> help this?
>
> Finally, I seem to have a relatively high number of dirty buffers and
> low number of free buffers, so I am evaluating the impact of adding
> additional DB Buffers. Will increasing the number of db buffers help
> either of the situations above?
>
> Any insight is appreciated.
>
> Thanks,
> Roy
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 16 1999 - 11:32:30 CDT