select sql_id, name, position,value_string from v$sql_bind_capture where sql_id='
Showing posts with label bind variable find value literal. Show all posts
Showing posts with label bind variable find value literal. Show all posts
Friday, April 03, 2009
How to find value used in bind variables
If sql statement used bind variables is still in shared pool, and you have Oracle 10g, you can find what values variables have in the following way:
select sql_id, name, position,value_string from v$sql_bind_capture where sql_id='';
select sql_id, name, position,value_string from v$sql_bind_capture where sql_id='
Etykiety:
bind variable find value literal
Subscribe to:
Posts (Atom)
