Re: Bind variables

On Thu, 12 Jul 2007 21:28:27 +0200, astalavista wrote:

> My question was :
> is it possible to see bind variables of a running query ??

Only in V10, in V$SQL_BIND_CAPTURE. Trace file is written when Oracle stops executing and starts waiting. Bind variables are written down after parse and bind phases but before execute phase. If the query is already executing, it's too late. You might try with process dump from oradebug, that will probably contain bind variables.

-- 
http://www.mladen-gogala.com