Bind Variable Peeking issue
- From: Balakrishna Y <krishna000@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 Sep 2009 12:26:54 +0530
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. 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
Other related posts:
