Re: dbms_support and not getting an explain plan

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 <Brandon.Allen_at_oneneck.com> 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.
>

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