Thursday, October 1, 2009

View Oracle Bind Variables version 10g 11g

Using grid control and v$sql you can see sql statements but to see the bind varibles in 10g and 11g you need to query the view v$sql_bind_capture.

select
sql_id,
t.sql_text SQL_TEXT,
b.name BIND_NAME,
b.value_string BIND_STRING
from
v$sql t
join v$sql_bind_capture b using (sql_id)
where
b.value_string is not null
and sql_id='&mysqlid'
/

No comments:

Post a Comment