RE: 10g slowdown

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 12 Dec 2008 15:20:05 -0700
Message-Id: <200812122220.mBCMK9MN032286@mail90c0.megamailservers.com>


Compare the optimizer_env values for the sqlid when run in sqlplus against the ones when run in SAP and see if there are any differences.

At 12:18 PM 12/12/2008, Blanchard William wrote:
>We looked at the program in SAP and the table & indexes in Oracle and
>nothing directly related to the query has changed. Is there anything
>that would cause Oracle to not use the right index in SAP but works fine
>when run in sqlplus?

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 12 2008 - 16:20:05 CST

Original text of this message