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: Why no row source plans in tkprof output? -- More info please read...

Re: Why no row source plans in tkprof output? -- More info please read...

From: Egor Starostin <egorst_at_gmail.com>
Date: Wed, 25 Apr 2007 11:41:20 +0400
Message-ID: <f0fc91970704250041vb725a31n2a946ea4504354dc@mail.gmail.com> 





Binh,



> I do see stats written for some of the SQL's in the raw trace file, however,

> there is no row source plans for any of the SQL's in the tkprof output file.




I believe you need to set statistics_level=all in order to get row
source execution statistics in STAT lines.



By default, statistics_level set to 'typical' value and although rows
source execution stats is gathered in v$segstat it doesn't displayed
in 10046 trace files.



-- 
Egor
http://www.oracledba.ru
--
http://www.freelists.org/webpage/oracle-l


Received on Wed Apr 25 2007 - 02:41:20 CDT












Original text of this message













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