shared_pool的字典缓存命中率

SYS@orcl> ed
Wrote file afiedt.buf

  1  select parameter,
  2   sum(gets),
  3   sum(getmisses),
  4   100*sum(gets-getmisses)/sum(gets) pct_succ_gets,
  5     sum(modifications) updates
  6  from v$rowcache
  7  where gets > 0
  8* group by parameter
SYS@orcl> /

PARAMETER     SUM(GETS) SUM(GETMISSES) PCT_SUCC_GETS    UPDATES
-------------------------------- ---------- -------------- ------------- ----------
sch_lj_oids     34   7    79.4117647   0
dc_tablespaces         78042  10    99.9871864   0
dc_awr_control    103   1    99.0291262   5
dc_object_grants         1259  93    92.6131851   0
dc_histogram_data        26455       1695    93.5928936   0
dc_rollback_segments         1073  21    98.0428705  21
dc_sequences     16  15     6.25  16
dc_segments         12448       1159    90.6892674  10
dc_objects         61633       2977    95.1697954 165
dc_histogram_defs        41623       5360    87.1225044  36
dc_users        107972        114    99.8944171   2

PARAMETER     SUM(GETS) SUM(GETMISSES) PCT_SUCC_GETS    UPDATES
-------------------------------- ---------- -------------- ------------- ----------
outstanding_alerts    58  11    81.0344828   5
dc_files    135   9    93.3333333   0
dc_global_oids          3672        103    97.1949891   0
dc_profiles    197   2    98.9847716   0
global database name         3147   1    99.9682237   0

16 rows selected.

SYS@orcl>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22126868/viewspace-764613/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22126868/viewspace-764613/