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>
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-lReceived on Fri Dec 12 2008 - 16:20:05 CST