I do have a query with multiple bind variables. I dont the value of those bind variables to pass, as well as I could not able to figure those values in trace file.
Now I am trying to run that sql with an additional hint (first_rows) and would like to capture that plan in baseline. How to capture baseline of that query with bind variables?
I thought I will enable automatic baseline acpture and then run this sql with hint and could see the baseline.
Any help will be appreciated!!
Click Here to Expand Forum to Full Width