Re: dbms_support and not getting an explain plan
- From: "Rick Ricky" <ricks12345@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Mon, 19 May 2008 13:24:28 -0400
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@xxxxxxxxxxx>
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.
>
Other related posts:
