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='';