Re: Bind variables

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Fri, 13 Jul 2007 03:01:07 GMT
Message-ID: <pan.2007.07.13.03.01.09@verizon.net>

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

Received on Thu Jul 12 2007 - 22:01:07 CDT