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