Re: 10053 trace PL/SQL

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 10.2.0.4 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,
>Rich

Hemant K Chitale

http://hemantoracledba.blogspot.com

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