v$filestat will give you the picture at the datafile/tablespace level..
if the phy blk read are identical to phy reads then they are
all sequential scans - ur index datafile will show this -
however if the no of blocks read is many times than the phyreads
then that datafile is experiencing FTS,
> ----------
> From: Libal, Ivo[SMTP:ivo.libal_at_knapp-systems.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, August 02, 2000 8:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: FULL SCANS
>
> Hello All
> is it possible to check which tables are read by full scans? Is it possible
> to make some script to check and log such a tables?
> Do I have to search all execution plains and find full scans or is it
> possible to get it from some wait events - how to make it automatically not
> reading v$session_waits?
> Do you have any experience with this problem?
> Thank you for your help
> Ivo Libal
>
>
> --
> Author: Libal, Ivo
> INET: ivo.libal_at_knapp-systems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Aug 02 2000 - 23:07:49 CDT
