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