- 最后登录
- 2017-8-31
- 在线时间
- 22 小时
- 威望
- 0
- 金钱
- 138
- 注册时间
- 2014-2-8
- 阅读权限
- 10
- 帖子
- 34
- 精华
- 0
- 积分
- 0
- UID
- 1661
|
1#
发表于 2014-6-24 11:31:41
|
查看: 2308 |
回复: 0
oacle 10.2.0.4.0
OS:RHEL 5.5
RAC环境
有一个奇怪的现象,其中一个实例数据字典命中率小于0,另一个是正常的,具体信息如下:
SQL> select sum(getmisses),sum(gets),(1- (sum(getmisses) / (sum(gets) + sum(getmisses)))) * 100 HitRate from v$rowcache where gets + getmisses <> 0
2 /
SUM(GETMISSES) SUM(GETS) HITRATE
-------------- ---------- ----------
288996141 -108341096 -59.971254
SQL> select cache#,parameter,gets,getmisses from v$rowcache where gets + getmisses <> 0
2 /
CACHE# PARAMETER GETS GETMISSES
---------- ------------------------------ ---------- ----------
2 dc_segments -2.031E+09 40072870
0 dc_tablespaces -2.079E+09 270722
5 dc_tablespace_quotas 263018 11377
6 dc_files 6735327 1563455
7 dc_users -2.014E+09 453419
3 dc_rollback_segments 241577525 322
8 dc_objects 1451380245 6990986
17 dc_global_oids -204796958 619554
12 dc_constraints 26044 9414
11 dc_object_ids 295974666 11985822
13 dc_sequences 1365325 109773
以上为部份信息
|
|