On Tue, 8 Feb 2005 14:29:04 -0500, "Oradba Linux"
<techiey2k3_at_comcast.net> wrote:
>
>"Thiko!" <biwombi_at_hotmail.com> wrote in message
>news:1107862438.607672.325800_at_f14g2000cwb.googlegroups.com...
>> Hi
>>
>> We have monitoring software which is telling us that many full table
>> scans are happening in the database.
>>
>> We want to reduce this if possible.
>>
>> Is there any SQL to use to tell what is doing the full tablescans?
>> e.g. the database user and the select statement? It is becoming
>> tedious checking the top sql and seeing if it doing full table scans.
>>
>> Many thanks.
>>
>> Thiko!
>>
>
>If you are oracle 9i then use v$sql_plan to find out which tables are being
>full scanned.
>But as others answered it might help to find the offending SQL and go from
>there.
>
v$session_longops should also do.
--
Sybrand Bakker, Senior Oracle DBA
Received on Tue Feb 08 2005 - 13:56:16 CST
