Re: Hot indexes

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 12 Jul 2004 10:50:13 +0300
Message-ID: <100b01c467e4$dd72cff0$bff923d5@porgand>

> If it really is a problem (somebody complaining, devices being
> overloaded, whatever), then you would need to track which user(s)/apps
> issued the LIO calls to the datablock adresses of this tablespace.
>
> Tracking of individual LIO calls including the file number, block number
> and number of blocks is externalized in v$session_wait and in 10046
> trace files (excluding exotic direct memory access methods and probably
> some decent 3rd party tools).

You probably meant tracking PIO calls here, since v$session_wait and 10046 trace arent able to report LIOs in detailed level. If one wanted to track LIOs, event 10200 could be used. But as you said, it would generate huge amounts of trace, probably 42TB in this case :)

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 12 2004 - 02:47:16 CDT