Bind Variable Peeking issue

From: Balakrishna Y <>
Date: Thu, 17 Sep 2009 12:26:54 +0530
Message-ID: <>

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 - 01:56:54 CDT

Original text of this message