Re: A brief doc on 10046 tracing
- From: Robyn <robyn.sands@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 12:33:40 -0400
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@xxxxxxxxxxx> 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.
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
