Re: received more blocks than served?

> Date: Tue, 08 Jul 2008 11:21:32 -0600
> From: Dan Norris <dannorris_at_dannorris.com>
> Subject: Re: received more blocks than served?
>
> I think Mark's suggestion about the different start times is probably the
> culprit. Flawed logic on my part--thanks Mark for pointing it out. Guess I
> was having a Monday :-|
> Dan

Dan and Mark,

I still don't understand. That seems to say that when RAC instances are started at different times, some blocks will be received from nowhere, or (as I see on some of my RAC nodes) some blocks will be sent to nowhere. Our current thinking is the cluster-wide total count by summing on gv$ views should still be balanced, taking into account other stats such as lost or corrupt blocks, blocks converted from current to CR, which are generally very small or 0. There must be something we're missing.

If the blocks are in transit between instances, the total count will not balance. But your query shows a big difference (SERVED - RECEIVED). I don't think we can explain that big number by blocks in transit.

Yong Huang       

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