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@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. 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.