Query Performing slow after upgrade to 11g

  • From: Veerabasaiah C <veeracb@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 1 Aug 2014 11:38:31 +1200

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

Attachment: extract_fail.sql
Description: Binary data

Attachment: TesaCompany.sql
Description: Binary data

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2014