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

  • From: "Egor Starostin" <egorst@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 Apr 2007 11:41:20 +0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: