Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.glorb.com!postnews1.google.com!not-for-mail
From: orclwzrd@yahoo.com (john)
Newsgroups: comp.databases.oracle.server
Subject: Logical reads
Date: 23 Apr 2004 07:28:51 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <4e062d34.0404230628.22e0c548@posting.google.com>
NNTP-Posting-Host: 65.174.243.238
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1082730531 6300 127.0.0.1 (23 Apr 2004 14:28:51 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 23 Apr 2004 14:28:51 +0000 (UTC)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260065

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