Re: dbms_support and not getting an explain plan

From: Rick Ricky <>
Date: Mon, 19 May 2008 13:24:28 -0400
Message-ID: <>

i seem to have more problems getting the plan using RAC in 10g. Anyone else notice this?

On Mon, May 19, 2008 at 12:36 PM, Allen, Brandon <> wrote:

> I have the same problem pretty frequently - it applies to all 10046
> traces, whether you get it from event 10046, sql_trace=true, dbms_support,
> etc. and I think it comes from tkprof not being able to properly sort out
> multiple queries with the same cursor number when there are multiple
> sessions for the same process so they're written to a single trace file.
> I think all you can do is go into the raw trace file and get the plan
> directly from the STAT lines. You might be able to edit the raw trace file
> and manually remove all other queries using the same cursor number and then
> run tkprof again and see if that works, but that could be a pretty tedious
> process.
> Regards,
> Brandon
> 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.

Received on Mon May 19 2008 - 12:24:28 CDT

Original text of this message