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

On 09/07/2005 04:38:26 PM, Hameed, Amir wrote:
> 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?

Pretty good idea. The statistics about the lost blocks is a TCP statistics. Oracle counts, somewhat misleadingly, TCP packets as blocks. I don't know what is your OS (almost anything is 64 bit these days), but if that is Linux, goverment's Department of Enron has a pretty decent Linux/TCP tuning page at: http://www-didc.lbl.gov/TCP-tuning/linux.html

-- 
Mladen Gogala
http://www.mgogala.com


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