To properly test a query in an Oracle database I need to show what values are being used in the bind variables used in the query. I have been told this is possible using DPA - please explain how or point me to the document explaining how.
Not sure who told you that is possible. That would require us to leverage tracing which we don't do (too much overhead on the monitored instance).
We will see the effects of the query after the substitution has actually happened (did the execution plan change).
We don't peek.
This is interesting - Thank You
