force_matching_signature
In this post I show you how to get SQL strings transformed in a way that resembles the result of cursor_sharing.
As we all know proper use of bind variables in SQL statements is a must to make transaction processing applications scalable. So how do we find the queries that don’t use bind variables and have to be parsed each time they are executed? There is number of ways, but this article is all about the most effective way I know. If you have a better one – let me know please!
Recent Comments