Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Is there any way we can find full table scan?
Mike F wrote:
> Is there any way we can tell whether there is a full table scan in our
> database and which table it is?
>
> Thanks
>
>
>
There isn't any nice view that tell you this. But there are several ways anyway. One is select sid,... from v_$sesstat where you have plenty of physical reads (stat# 40) and/or table scans (stat# 162). Then look in v$sql or the like to grap the statements causing scans. Use explain plan or some other tool to verify and then tune the statements. /Svend Jensen Received on Sat Feb 23 2002 - 01:34:19 CST