Re: SHARED_POOL_SIZE

Susanne,

By Reloads do you mean Ratio?

Was the database cold when you ran this query?

Regards,
Jason

On Wed, 28 Jul 1999 13:28:35 +0200, "susanne mainz" <smainz_at_debis.com> wrote:

>Hi,
>in an ORACLE8 DBA course I learned to find out the optimal size for the
>shared pool via the following SQL query:
>
>select
>sum(gets) "DD Gets",
>sum(getmisses) "DD Cache Get Misses",
>100*(sum(getmisses)/(sum(gets)) "%Reloads"
>from v$rowcache;
>
>Reloads should be less than 1%. Taking the default values for a midddlesized
>DB in the Init.ora the percentage of reloads of my DB are far beyond 1%,
>near 10% in fact.
>
>Is it possible that 1% is only a misprint?
>
>Susanne
>
Received on Wed Jul 28 1999 - 10:49:33 CDT