How about doing logminer? v$logmnr_content.DATA_BLK#
On 12/15/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Anybody have a good method for tracking top SQL by 'db block changes'? It
> seems this statistic is only tracked by session and instance, but not by SQL
> statement. The 'disk_reads' are tracked in v$sql and although it wouldn't
> make sense to track 'disk_writes' (since physical writes are performed in
> the background as needed by DBWR, not as a direct result of any particular
> SQL statement), it seems like it would make sense to track 'db block
> changes' by SQL, doesn't it?
>
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Dec 18 2005 - 07:20:03 CST
