Re: Logical reads

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 24 Apr 2004 18:10:36 +1000
Message-ID: <408a20f7$0$25655$afc38c87@news.optusnet.com.au>

john wrote:
> Anybody have any insight into the difference between the statistics
> 'session logical reads' and 'consistent gets' + 'db block gets' at
> both the session and system level. Usually the logical reads is
> determined by consistent gets + db block gets, session logical reads
> does not always equal this value. I'm just wondering why and if
> there's any reason to use one over the other. I've seen it both ways
> but not really any explanation. Seems that both should be correct.
>
> John Parker
> parkerj at tusc dot com

Well, what do your friends at TUSC say on the matter?

HJR Received on Sat Apr 24 2004 - 03:10:36 CDT