Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Finding full-table scans?

Re: Finding full-table scans?

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Fri, 4 Apr 2003 08:18:42 -0800
Message-ID: <LDSdnbRIDpP_LRCjXTWcoQ@giganews.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.

Received on Fri Apr 04 2003 - 10:18:42 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US