My Oracle Support Banner

升级到 12c 之后'Global Cache Blocks Lost' 或 'gc blocks lost'的失败增长 (Doc ID 2404279.1)

Last updated on FEBRUARY 03, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.1.0.2 到 12.1.0.2 [发行版 12.1]
本文档所含信息适用于所有平台

症状

升级到 12c 之后‘gc blocks lost’增长,我们可以看到


1. 统计数据持续增长:

 

SELECT A.INST_ID "INSTANCE", A.VALUE "GC BLOCKS LOST",
B.VALUE "GC CUR BLOCKS SERVED",
C.VALUE "GC CR BLOCKS SERVED",
A.VALUE/(B.VALUE+C.VALUE) RATIO
FROM GV$SYSSTAT A, GV$SYSSTAT B, GV$SYSSTAT C
WHERE A.NAME='gc blocks lost' AND
        B.NAME='gc current blocks served' AND
        C.NAME='gc cr blocks served' and
        B.INST_ID=a.inst_id AND
        C.INST_ID = a.inst_id
/

<< 12.1.0.2>

11:02:14 SQL> /

  INSTANCE GC BLOCKS LOST GC CUR BLOCKS SERVED GC CR BLOCKS SERVED      RATIO
---------- -------------- -------------------- ------------------- ----------
         1            573                79063               36031 .004978539
         2            337                36154               63131 .003394269


11:07:03 SQL> /

  INSTANCE GC BLOCKS LOST GC CUR BLOCKS SERVED GC CR BLOCKS SERVED      RATIO
---------- -------------- -------------------- ------------------- ----------
         1            573                79084               36112 .004974131
         2            338                36176               63181 .003401874

<< 11.2.0.3>>

11:02:52 SQL> /

  INSTANCE GC BLOCKS LOST GC CUR BLOCKS SERVED GC CR BLOCKS SERVED      RATIO
---------- -------------- -------------------- ------------------- ----------
         1              0                 7687                  49          0
         2              0                   34                  33          0

11:07:13 SQL> /

  INSTANCE GC BLOCKS LOST GC CUR BLOCKS SERVED GC CR BLOCKS SERVED      RATIO
---------- -------------- -------------------- ------------------- ----------
         2              0                   36                  55          0
         1              0                 7696                  49          0

 

2. 如果使用了 EM,你可能看到产生了类似如下的警告:

Host=node1
Target type=Database Instance
Target name=<target name>
Categories=Error
Message=Metrics Global Cache Blocks Lost is at 4
Severity=Warning
Event reported time=Apr 2, 2015 2:50:27 AM CDT
Operating System=Linux
Platform=x86_64
Associated Incident Id=298857
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=rac_global_cache:lost
Metric Group=Global Cache Statistics
Metric=Global Cache Blocks Lost
Metric value=4
Key Value=
Rule Name=Database Availability and Critical States <DBA_owner>,Metric Alerts
Event Rule
Rule Owner=<DBA_owner>
Update Details:
Metrics Global Cache Blocks Lost is at 4

 

 

更改

 客户从 11.2.0.3 升级到 12.1.0.2

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


文档内容
症状
更改
原因
解决方案
参考

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.