MIB Viewer

oramodMetricsSGADDCE

OBJECT-TYPE
1.3.6.1.4.1.546.16.4.11.2.1.1.21
Access
read-only
Status
mandatory
Sub-identifiers
0
Data Dictionary Cache Efficiency Percentage scaled by 100. Shows the ratio of gets to misses within the shared pool. The ratio should be less than 0.1. Various database operations cause the RDBMS to access its system tables. These system tables are stored in the Oracle data dictionary. The objects in the data dictionary are stored in the system tablespace. When the RDBMS needs access to its system tables, the tables are read into the data dictionary cache. Resizing the shared pool can affect this ratio.
Gauge