RE: 10g slowdown

William,

You can also compare all rows in v$ses_optimizer_env for the SAP session and the sqlplus session. In case the SAP session set some events early on, find them by SQL trace with a session logon trigger, or oradebug setos(ora)pid xxx
oradebug dump events 1
and read the trace file.

Also, when checking another session's execution plan, explain plan should not be used. Use v$sql_plan or dbms_xplan.display_cursor.

Yong Huang

> 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