From:Steve Adams
Date:27-Mar-2001 06:22
Subject:   Tuning the dictionary cache

A low hit rate on dc_objects is a perfectly normal symptom of the use of public synonyms. If SCOTT parses the statement "SELECT * FROM DUAL;" then the session will first attempt a get against the dc_objects cache for SCOTT.DUAL. This will of course result in a miss. Thus the hit rate on dc_objects is more a reflection on the extent to which objects are referenced via public synonyms, rather than the effectiveness of the dictionary cache.

Yes, it could be dc_objects but the question still remains the same.

Are you sure that you don't mean dc_objects rather than dc_object_ids?

It is common to have an acceptable overall dictionary cache ratio while the individual dictionary cache component (i.e. dc_object_ids) can have a poor hit ratio. I can increase the shared_pool_size, but sometimes this will not significantly improve the individual component in question. Is there any other way to tune this?