Re: Logical Reads flow in blocks/second: how can you compute it ?

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Fri, 26 Mar 2004 11:57:37 +0100
Message-ID: <c4129j$n9f$1@news.mch.sbs.de>

Spendius wrote:
> There's a tool I once saw that displays a stream (amongst
> many other things) between the SGA and the processes of
> the server, that represents if I correctly recall the flow
> of blocks per second between them.
>
> How can you calculate such value ? What SQL statement gives
> you that value ?

Hi,
sounds like quest "spotlight on oracle". The number of buffer gets can be determined using:
select value from v$sysstat where name='session logical reads"

run this query, wait 10 secs, run again, calc the difference and you're done.

Stephan Received on Fri Mar 26 2004 - 04:57:37 CST