RE: How to find current value of bind variables

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>
  • Date: Thu, 1 Sep 2005 12:54:26 -0700

I checked that out, but it only shows variables for your own session (unless 
I'm missing something - please correct me if I'm wrong).  I need to find the 
variable settings for another user's session.

-----Original Message-----
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Thursday, September 01, 2005 12:50 PM
To: Allen, Brandon
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: How to find current value of bind variables

You might examine V$SQL_BIND_DATA.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On 9/1/05, Allen, Brandon < Brandon.Allen@xxxxxxxxxxx> wrote: 

Does anyone know if there is a way to find out what values are in effect for 
the bind variables of a currently running query?
I know how to find bind variable values with a trace, but that requires you to 
start a trace prior to the parsing of the query and it's too late for that.

Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: