RE: How to find current value of bind variables

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.  

Thanks  

-----Original Message-----

From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Thursday, September 01, 2005 12:50 PM To: Allen, Brandon
Cc: oracle-l_at_freelists.org
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_at_oneneck.com> 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.  

Thanks,
Brandon  

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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 01 2005 - 15:40:20 CDT