Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Any thoughts? Date: Thu, 29 Apr 2004 21:23:50 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.verwijderdit.demon.nl References: <4e062d34.0404290314.6eb7828c@posting.google.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 23 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260419 On 29 Apr 2004 04:14:53 -0700, orclwzrd@yahoo.com (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. > >Of course, if I've missed the answer already posted sometime before, >that would be nice to know too. > >Thanks for any feedback > >John Please ask your friends at Tusc They are theself-proclaimed gurus, aren't they? -- Sybrand Bakker, Senior Oracle DBA