RE: 10g slowdown
Date: Sat, 13 Dec 2008 06:56:59 -0800 (PST)
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.
> 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