[SQL TUNING]The bind variables in a query

Hi,

What do I do when I find:

SELECT XXX, YYY, FROM ZZZ ....
WHERE XXX = BindVariable:

in the shared pool,

and I want to perform an explain plan on that query?

Obviously depending on the number of rows selected, my SQL tuning strategy varies a lot.

I need to know the value in the variable at runtime.

If anyone has an idea, please let me know. Received on Mon Nov 14 2005 - 08:59:06 CST