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

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


Other related posts: