Sv: SHARED_POOL_SIZE

No, 1% is a good guideline.

If you have installed at standard database your Shored_pool_size should be at least 9 MB (large in default init.ora) .

Remember, more memory for shared_pool_size will give better performence.

/karsten weikop

susanne mainz <smainz_at_debis.com> skrev i en nyhedsmeddelelse:7nmpgd$vto$1_at_news.hamburg.pop.de...
> 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 - 07:28:36 CDT