Re: 10053 trace for sql fired from pl/sql (stored code)

Ah, ok, I missed your email with problem description.

I can't help with getting the CBO trace, but how do you detect execution plan changes? By checking the STAT lines from 10046 or v$sql_plan?

Tanel.

• Original Message ----- From: "Boris Dali" To: ; "ORACLE-L" Sent: Thursday, December 22, 2005 6:09 PM Subject: Re: 10053 trace for sql fired from pl/sql (stored code)

> Tanel,
>
> I thought I did. I simply need to get a cbo trace in
> 9i of a sql that is executed from a stored code
> (packaged stored procedure). Please take a look at a
> simple snippet of code in my earlier email
>
> Thanks,
> Boris Dali.
>

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