SHARED_POOL_SIZE

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 - 06:28:35 CDT