Re: 10053 trace for sql fired from pl/sql (stored code)
- From: Boris Dali <boris_dali@xxxxxxxx>
- To: tanel.poder.003@xxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Dec 2005 19:44:42 -0500 (EST)
Both. Plus the users screaming ... from time to time,
which actually prompts me to check both.
Thanks,
Boris Dali.
--- Tanel Põder <tanel.poder.003@xxxxxxx> 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" <boris_dali@xxxxxxxx>
> To: <tanel.poder.003@xxxxxxx>; "ORACLE-L"
> <oracle-l@xxxxxxxxxxxxx>
> 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.
> >
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________________
Find your next car at http://autos.yahoo.ca
--
//www.freelists.org/webpage/oracle-l
Other related posts:
