RE: Why no row source plans in tkprof output?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <knecht.stefan@xxxxxxxxx>, <binhpham15@xxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Apr 2007 09:23:48 -0700
Also make sure your max_dump_file_size is big enough so that the file
doesn't get closed by the size limit before the STAT lines can be
written to it.
Regards,
Brandon
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stefan Knecht
The STAT lines (row source operations) only get dumped in the tracefile
when the cursor gets closed. If, for example, you're tracing a running
session for a short period of time, you may not get any plans in the
tracefile (and hence in tkprof).
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.
Other related posts:
