Menu Content/Inhalt
Home arrow Oracle arrow tipsntricks arrow Get bind values for a query in the cursor cache
Get bind values for a query in the cursor cache PDF Print E-mail
Written by Martin   
Friday, 14 May 2010

I can never remember the syntax, but this worked for me:

accept v_sql_id prompt "enter sql id: "

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='&v_sql_id'
/
 
< Prev   Next >