Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Any thoughts?

Re: Any thoughts?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 30 Apr 2004 07:25:01 +1000
Message-ID: <409172a6$0$29255$afc38c87@news.optusnet.com.au>


Bricklen wrote:

> Sybrand Bakker wrote:
> 

>> On 29 Apr 2004 04:14:53 -0700, orclwzrd_at_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
> 
> 
> Just curious Sybrand, but how did you determine that this poster has 
> friends at TUSC?


Because he has a memory like an elephant, I guess! John posted the same query just a few weeks ago and included his TUSC email address (which he probably is beginning to wish he hadn't!).

Regards
HJR Received on Thu Apr 29 2004 - 16:25:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US