Interprating Dictionary Cache stats
555329Sep 17 2008 — edited Sep 18 2008Hello Everyone,
Working on 10g/windows
I got the follwing contents from the AWR.
Dictionary Cache Stats
"Pct Misses" should be very low (< 2% in most cases)
Cache Get Pct Miss
Requests
dc_awr_control 65 0.00
dc_constraints 1,749 42.54
dc_files 5 0.00
dc_global_oids 4,479 0.42
dc_histogram_data 9,094 0.32
dc_histogram_defs 10,338 10.40
dc_object_grants 566 4.24
dc_object_ids 55,123 1.36
dc_objects 11,681 9.59
dc_profiles 462 0.00
dc_rollback_segments 687 0.00
dc_segments 6,825 4.78
dc_sequences 191 10.99
dc_table_scns 49 100.00
dc_tablespace_quotas 1,327 0.53
dc_tablespaces 33,068 0.01
dc_usernames 4,628 0.11
dc_users 53,443 0.01
global database name 3 0.00
outstanding_alerts 76 1.32
Question:
As stated abvoe, the PCT_Misses should be <2, but I'm wondering how can I explain the above PCT_misses bolded?
Thanks