RE: 10g slowdown
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, William.Blanchard@xxxxxxxxxx
- Date: Sat, 13 Dec 2008 06:56:59 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
