Re: Dictionary Cache Size Formula ???

Ibrahim DOGAN wrote:

> We have very low dict. cache hit ratio, around 80%.
>
> Dict cache size is 6M and shared pool is 237MB.
>
> I have no clue about the internal formula Oracle applies to 'shared
> pool' to set dict cache size but even if we double the shared pool,
> dict cache size doesn't budge much (7-8M) and we still get very low
> dict cache hit ratio?
>
> Any workaround to directly increase the size of dict cache?
>
> Thanks in advance
> i.d.

What version of Oracle?

But run this SQL:

SELECT *
FROM v_$sgastat
WHERE name LIKE 'dict%';

Daniel Morgan Received on Thu Mar 20 2003 - 10:56:59 CST