Re: 10g slowdown

From: David Barbour <>
Date: Fri, 12 Dec 2008 16:40:28 -0500
Message-ID: <>


What versions of SAP and Oracle are you using? SAP is really funny about bind peeking and recommends setting the hidden parameter _optim_peek_user_binds to 'FALSE'. There are also several events you should have set (depending on your version of Oracle and SAP) to 'assist' Oracle in executing a correct plan when confronted with SAP generated code.

Check the differences between your active parameters and events in QA and PRD. On Fri, Dec 12, 2008 at 3:48 PM, Allen, Brandon <>wrote:

> I think that's pretty common and not necessarily a bug. I'm not 100%
> positive, but I seem to remember reading somewhere that v$sql_shared_cursor
> by design only shows some, but not all, of the reasons for not sharing
> cursors.
> Regards,
> Brandon
> -----Original Message-----
> From: []
> On Behalf Of Rich Jesse
> Beware that there is also what I believe to be a bug where all values for
> the columns in v$sql_shared_cursor are "N", despite multiple children.
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
> --

Received on Fri Dec 12 2008 - 15:40:28 CST

Original text of this message