RE: 10g slowdown

From: Wolfgang Breitling <>
Date: Fri, 12 Dec 2008 15:20:05 -0700
Message-Id: <>

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?


Wolfgang Breitling
Centrex Consulting Corporation

Received on Fri Dec 12 2008 - 16:20:05 CST

Original text of this message