Queries doing full scan

We need know how to find queries that is doing full scan table.

With the next query we obtein the number of full table scans against tables:

select n.name, s.value
from v$statname n , v$sysstat s
where n.statistic# = s.statistic#
order by n.class, n.name

but we have not the sql that doing full scan. With the view v$sqlarea I obtein the executions, disk_reads, .... of either query but not the full scan.

Someone can help me, please? Received on Tue Nov 30 2004 - 06:51:26 CST