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 -> Finding full-table scans?

Finding full-table scans?

From: Sarah Billings <rukind68_at_yahoo.com>
Date: 4 Apr 2003 07:33:35 -0800
Message-ID: <b7b5fcac.0304040733.58fccdb6@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 - 09:33:35 CST












Original text of this message













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