Re: Finding full-table scans?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Fri, 4 Apr 2003 16:04:51 -0800
Message-ID: <yapja.15$1%6.143@news.oracle.com>

select * from v$sql_plan

where operation = 'TABLE ACCESS'

and options = 'FULL'

and object_name in (

select table_name from all_tables

where blocks > 1000

)

grouping is left as an exersize to the reader.

"Sarah Billings" <rukind68_at_yahoo.com> wrote in message news:b7b5fcac.0304040733.58fccdb6_at_posting.google.com...
> I am trying to figure out the v$sql_plan view so that I can display
> counts of all tables that are over 300 blocks and are getting
> full-table scans.
>
> Has anyone had experience with this?
>
> Thanks in advance. S.
Received on Fri Apr 04 2003 - 18:04:51 CST