18.4 Dictionary Cache Hit Ratio

---

This ratio looks at buffer activity versus disk activity for database metadata. How well is metadata accessed in memory from the shared pool without having to resort to physical disk activity?

SELECT 'Dictionary Cache Hit Ratio ' "Ratio" ,ROUND((1 - (SUM(GETMISSES)/SUM(GETS))) * 100,2)||'%'     "Percentage" FROM V$ROWCACHE;     Ratio                         Percentage ---------------------------   ---------- Dictionary Cache Hit Ratio        99.86%

---