> 1. is it possible to get the bind variable from a query, if you start the > trace after the query has started? I have been using 10046 trace. Any other > traces that might get this? Maybe not exactly what you're looking for, but V$SQL_BIND_CAPTURE may have the *last* bind variables used. It's probably worth a look anyway. I use it extensively to troubleshoot bind/skew issues in v10.1. GL! Rich -- //www.freelists.org/webpage/oracle-l