Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!border3.nntp.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 04 Apr 2003 10:18:42 -0600
From: "Gabriel Gonzalez" <no-spam@no-spam.com>
Newsgroups: comp.databases.oracle.server
References: <b7b5fcac.0304040733.58fccdb6@posting.google.com>
Subject: Re: Finding full-table scans?
Date: Fri, 4 Apr 2003 08:18:42 -0800
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <LDSdnbRIDpP_LRCjXTWcoQ@giganews.com>
Lines: 12
X-Trace: sv3-1ylpFLjzSkfg7V5I0NLMrFjTBshSBMiYYi/dzGeoNSucm1qAIgFxjapiIV/duMgAmHZuy78w5f9Vf0g!qEam2iAzK8rOyqKajAh1crQYlxURr33cQ7OXPNwgcOIlmrPQRDfXKztMR1FF
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newsfeed1.easynews.com comp.databases.oracle.server:182006
X-Received-Date: Fri, 04 Apr 2003 09:18:25 MST (news.easynews.com)

Have you looked into EXPLAIN PLAN?  Look at the docs for it
(tahiti.oracle.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.