RE: Bind Variable Peeking issue

Have you tried disabling that feature?

This is how you disable it:    

http://sanoralife.blogspot.com/2009_02_01_archive.html
<http://sanoralife.blogspot.com/2009_02_01_archive.html>
 

Regards,
Santhosh Channa

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

From: Balakrishna Y [mailto:krishna000_at_gmail.com] Sent: Thursday, September 17, 2009 2:57 AM To: oracle-l_at_freelists.org
Subject: Bind Variable Peeking issue  

Hi All,

Tom has explained very well about resolving performance problem after enabling sql_trace=true .
http://tkyte.blogspot.com/2007/09/tuning-with-sqltracetrue.html
<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.

Regards

Bala

--
http://www.freelists.org/webpage/oracle-l