Re: Query Performing slow after upgrade to 11g

How are you gathering stats? Are you using coe_siebel_stats?

You may want to read this: http://carlos-sierra.net/2013/07/25/gathering-cbo-statistics-in-oracle-applications/

Cheers -- Carlos Sierra

> On Jul 31, 2014, at 7:38 PM, Veerabasaiah C <veeracb_at_gmail.com> wrote:
>
> Hi All,
>
> We recently upgraded our database from Oracle 9i to Oracle 11g.
>
> In Oracle 9i we were using RULE based optimizer as it was the need from the application.
>
> Attached query used to finish in about 30 mins in the old one, but after upgrade we are seeing this query hanging in there forever almost.
>
> From the plan it is doing a "Merge Cartesean" which I think is causing the slowness. Need some help to fix.
>
>
> --
> Veerabasaiah C B
>
> <extract_fail.sql>
> <TesaCompany.sql>

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