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

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: 2005-12-23 01:44:42
Message-id: 20051223004442.61308.qmail@web32808.mail.mud.yahoo.com

Both. Plus the users screaming ... from time to time, which actually prompts me to check both.

Thanks,
Boris Dali.

• Tanel Põder wrote:

> 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
>
>
>
                                  

---

Find your next car at http://autos.yahoo.ca

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

Received on Fri Dec 23 2005 - 01:44:42 CST