|Literals, Substitution Variables and Bind Variables - The article compares the affect of using literals, substitution variables and bind variables on memory and CPU usage.|
Scott said...Great article! This information is very helpful in understanding the parsing process in Oracle. Thank you!!!
Anand said...very nice article.we can also achieve this by cursor_sharing value to exact/force but I don't no demerit of this parameter
The CURSOR_SHARING parameter is a quick fix when you are not able to do the job properly. It is not a solution in itself and it is certainly not more efficient thann using bind variables in the first place. You should only use this parameter if you can't go back and fix bad code. You should certainly not plan on using CURSOR_SHARING in a new project.
Ravi Kumar Gupta said...This is very useful to understand how Bind variable works and how the data is stored in Shared Pool where bind variable make it remain constant for predictable sql statment.Example's are really good.
Amir said...This is the simplest example to elaborate Literals, Substitution Variables, Bind Variables, soft parse and hard parse.....Great Work...
eshwar said...yeah its nice