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

I think there was some confusion here - you are just looking for the basic STAT (aka Row Source Operation) lines, which are written to the trace file when the cursor is closed as previously mentioned. What Egor was talking about is the execution statistics, e.g. consistent gets, physical reads, etc. that are also included for each STAT line only if STATISTICS_LEVEL=ALL.   Regards,
Brandon

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Binh Pham

Egorts,

Thanks for the reply but I do not think so since our instance has that set to TYPICAL and here is the test I did below:

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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