Database Software

Hello everyone,

I'm having a strange issue with my 11.1.0.7.0 cluster database. This is a two node RAC cluster on RHEL 4 update 8 was upgraded to 11g about a year ago.

The issue that we're having is that we are seeing the GC Blocks Lost event in the database, however this does not seem to coincide with UDP errors or interface errors on the server.

This is the session statistics for the affected user:
INST_ID SID OSUSER USERNAME PROGRAM NAME VALUE
2 2694 msmith Test program.exe gc blocks lost 888

As you can see Oracle is reporting 888 blocks lost.

Here are the UDP stats from both nodes:

Node 1:
Udp:
397593 packets received
849 packets to unknown port received.
0 packet receive errors
564490 packets sent

Node 2:
Udp:
540633 packets received
815 packets to unknown port received.
0 packet receive errors
373315 packets sent

Node 1 eth1:
inet addr:10.0.0.1 Bcast:10.0.0.255 Mask:255.255.255.0
inet6 addr: fe80::217:a4ff:fe47:ce8c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:384695 errors:0 dropped:0 overruns:0 frame:0
TX packets:1403670 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:281467364 (268.4 MiB) TX bytes:1736827123 (1.6 GiB)
Interrupt:177 Memory:fa000000-fa011100

Node 2 eth1:
inet addr:10.0.0.2 Bcast:10.0.0.255 Mask:255.255.255.0
inet6 addr: fe80::213:21ff:fe0e:2c8e/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1408369 errors:0 dropped:0 overruns:0 frame:0
TX packets:389885 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1740313558 (1.6 GiB) TX bytes:285556367 (272.3 MiB)
Interrupt:177 Memory:fa000000-fa011100

Any ideas? I have a ticket open with Oracle, but I wanted to see if anyone else in the community has ran into something similar.

Thank you for all your help!