Re: Hot indexes
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Jul 2004 10:50:13 +0300
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
