Re: 10053 trace PL/SQL
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: richa03@xxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 02 Sep 2010 11:28:50 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
