Try increasing the shared pool size parameter in your init.ora
> -----Original Message-----
> From: Beginner [SMTP:knng_at_hkstar.com]
> Posted At: 16 April 1998 16:46
> Posted To: server
> Conversation: How to Tune Data Dict. Cache in Ora8?
> Subject: How to Tune Data Dict. Cache in Ora8?
>
> Hello,
>
> I found that the hit ratio of my company DB is very strange, the
> hit ratio of 'dc_constraint' is always about 73.43%. However, the
> other
> dc_ hit rate can maintenance in 95-97%. I know that we have the way to
> configure dc_ cache in init.ora file in previous version of Oracle.
> But
> it is not found in Ora8.
>
> Is there any way to configure it other than increase in SGA size?
>
> Thank you for attention.
>
> Kelvin
Received on Thu Apr 16 1998 - 11:02:38 CDT
