Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Finding bind variables a session is using

Finding bind variables a session is using

From: <1443131_at_usenetplanet.com>
Date: Thu, 07 Feb 2002 17:59:44 GMT
Message-ID: <3c62bf73.269412144@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.
Received on Thu Feb 07 2002 - 11:59:44 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US