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 sql's that are doing FTS.

Re: Finding sql's that are doing FTS.

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Tue, 25 Jan 2000 13:53:36 -0000
Message-ID: <86k9vq$erb$1@kermit.esat.net> 





Or you could in Sqlplus, just


set autotrace on


and run the query.


Be sure to have the plan_table installed first though



Andreas Michler wrote in message


>


>> How do I easily find sql's that are doing full table scans (FTS).


>>


>


>




Received on Tue Jan 25 2000 - 07:53:36 CST












Original text of this message













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