RE: Bind Variable Peeking issue

From: Channa, Santhosh <>
Date: Thu, 17 Sep 2009 10:28:53 -0400
Message-ID: <>


Have you tried disabling that feature?

This is how you disable it:

Santhosh Channa

P Consider the environment. Please don't print this e-mail unless you really need to.

From: Balakrishna Y [] Sent: Thursday, September 17, 2009 2:57 AM To:
Subject: Bind Variable Peeking issue  

Hi All,

Tom has explained very well about resolving performance problem after enabling sql_trace=true .
<> .
Today i have a similar problem after enabling sql_trace its working fine or else its taking around 20 mintutes to validate one invoice.

Since this is a production Environment i can't flush the shared pool and what i have decided in order the change the plan i have Gathered stats on one table which was involved in that query with no_invalidate=>false option. Execution plan got invalidated and as per my assumption it should hard parse the query and choose the new plan but still my problem is not resolved.

To resolve this problem i have enable sql trace again . Can any have some clues on this please ..

We are using Version.



Received on Thu Sep 17 2009 - 09:28:53 CDT

Original text of this message