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 -> Re: how to find the SQL statement in V$SQLAREA with bind variable

Re: how to find the SQL statement in V$SQLAREA with bind variable

From: <yong321_at_yahoo.com>
Date: 2 May 2005 20:45:48 -0700
Message-ID: <1115091948.458608.84030@f14g2000cwb.googlegroups.com> 





Once you upgrade to 10g, you can use v$sql_bind_capture.value_string to
look at the bind variable runtime value for a SQL statement, subject to
some limitation. Before 10g, you use 10046 event at level 4 (of course
level 12 also works).



Yong Huang
Received on Mon May 02 2005 - 22:45:48 CDT












Original text of this message













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