RE: High "global cache blocks lost" statistics on one RAC node

From: <Ravi_Kulkarni_at_Dell.com>
Date: Wed, 7 Sep 2005 17:22:27 -0500
Message-ID: <DB108C8A1E08EC448BB22A51DC9FAB62750388@ausx3mpc111.aus.amer.dell.com>

Amir,

Does your netstat -i list any non-zero values for RX-ERR / TX-ERR for any of the nodes ?

Also netstat -s for UDP should have negligible errors. Check both netstat -i & -s for BOTH instances. (Switches may vary with your *nix. Following is on Linux)

$ netstat -i
Kernel Interface table
Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg

bond1      1500   0 16359630      0      0      0 16963867      0      0
0 BMmRU

$netstat -s
..

Udp:

    12577981 packets received
    162 packets to unknown port received.     0 packet receive errors
    12466995 packets sent
..

Thanks,
Ravi.

From: racdba-bounce_at_freelists.org [mailto:racdba-bounce_at_freelists.org] On Behalf Of Hameed, Amir
Sent: Wednesday, September 07, 2005 3:38 PM To: racdba_at_freelists.org; oracle-l_at_freelists.org Subject: High "global cache blocks lost" statistics on one RAC node

I have a two-node RAC running an 11i-ebusiness suite (11.5.9/9.2.0.6 64-bit). I am seeing the following from Statspack:

Inst    Statistic                                             Total

per Second per Trans

-----   ---------------------------------------- ------------------
-------------- ------------ 
1.      global cache blocks lost                                 28
0.0          0.0 
2.      global cache blocks lost                              4,410
2.7          0.9

We are using three giga-bit private interconnects going through a switch. This does not see like an interconnect issue otherwise, I think, I would have seen a higher number on the 1 node as well.

Any idea what might be causing it?

Thanks
Amir

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 07 2005 - 17:24:27 CDT