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: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 4 Aug 2006 16:30:45 +0100
Message-ID: <7765c8970608040830n7d6d649ble2787e949303df6b@mail.gmail.com> 





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






On 8/4/06, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:


>

>  We have found that we do not always get the 10046 explain plan that gives

> us the LIO and PIO for each row source with a level 12 report.

>





-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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


Received on Fri Aug 04 2006 - 10:30:45 CDT












Original text of this message













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