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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.