RE: 10g slowdown
Date: Fri, 12 Dec 2008 15:20:05 -0700
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?
Centrex Consulting Corporation