Bind Variable Peeking issue
Date: Thu, 17 Sep 2009 12:26:54 +0530
Tom has explained very well about resolving performance problem after
enabling sql_trace=true .
http://tkyte.blogspot.com/2007/09/tuning-with-sqltracetrue.html. 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 10.2.0.2 Version.
BalaReceived on Thu Sep 17 2009 - 01:56:54 CDT