Re: 10053 trace PL/SQL

From: Hemant K Chitale <>
Date: Thu, 02 Sep 2010 11:28:50 +0800
Message-Id: <>

Have you tried an EVENT 10132 trace ? My notes have this description : "Dump execution plan at hard parse (does not require level)" I can't remember where I got it from. (Tanel or Jonathan or ??)

The messages file says :
10132, 00000, "dump plan after compilation" // *Cause:
// *Action: set this event only under the supervision of Oracle

Heman K Chitale

At 11:11 PM Wednesday, Rich wrote:
>Hello List,
>This is 64-bit on RHEL 5.1 x86_64.
>I have a small PL/SQL procedure which is using the "wrong" index.
>The SQL only does this within the procedure - I cannot replicate the
>issue externally with SQL*Plus.
>I'd like to run a 10053 trace on it to determine why.
>Thanks in advance,

Hemant K Chitale

Received on Wed Sep 01 2010 - 22:28:50 CDT

Original text of this message