Re: A brief doc on 10046 tracing

Brandon - I've been making the assumption the dbms_supp package wouldn't give me all the information, but I'll check it out.

And you're right - I'll add the tkprof commands as well.

thanks .. Robyn

On 7/20/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> I've used the dbms_supp package with 8.0.6, 8.1.7 and 9.2 so I know it works (with BINDs and WAITs) for all those versions at least. A couple other things to be aware of - you have to run $ORACLE_HOME/rdbms/admin/dbmssupp.sql first to create the package (it's not installed by default), and this script didn't ship with all versions so sometimes you have to copy it from one install to another, or ask Oracle Support for it. Also, I would recommend to end a trace by cleanly logging out the traced process whenever possible (rather than using stop_trace_in_session) so the STAT lines are written to the end of the file (assuming you haven't exceeded max_dump_file_size) because these lines are very useful - they show the explain plan used at execution time (shown as Row Source Operation in tkprof output), along with the stats for each step of the explain plan. That's another thing you might want to cover in your doc - tkprof.
>
>

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