Re: Finding bind variables a session is using

<1443131_at_usenetplanet.com> wrote in message news:3c62bf73.269412144_at_64.154.60.165...
>
>
> Given a Session ID (SID from v$session), is there some way to find
> what bind variables that the session is using? I know there are views
> called v$sql_bind_data and v$sql_bind_metadata, but I do not know what
> records are related to which session. I believe ADDRESS column of
> v$sql_bind_metadata should give some direction, but I do not know
> where to join this. Thank you in advance.
>
>
>
>

v$sqlarea or v$sqltext_with_newlines or v$open_cursor are likely candidates.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address