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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: problem consistently getting explain plan with 10046 trace

Re: problem consistently getting explain plan with 10046 trace

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 05 Aug 2006 11:44:31 -0400
Message-Id: <1154792671l.2689l.0l@medo.noip.com> 






On 08/04/2006 11:30:45 AM, Niall Litchfield wrote:


> as well as Raj's comment you could also look at v$sql_plan if you are on a

> recent release




Recent release means "9.2 or newer". Essentially, if the database was not 
built to support Trojan  wars, it does have V$SQL_PLAN


-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l


Received on Sat Aug 05 2006 - 10:44:31 CDT












Original text of this message













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