It indicates the percentage of time the data dictionary objects are read from memory rather than on disk.
The value should be greater than 95%. If less then increase the shared pool (SHARED_POOL_SIZE init parameter).
Run hitratio script to get dictionary cache hit ratio.
A cache miss on Dictionary and Library cache is more expensive than a miss on buffer cache.
Thanks
Friday, July 3, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment