From:Steve Adams
Date:28-Mar-2001 08:58
Subject:   Finding bind variable values

V$SQL_BIND_DATA gives you bind values for open cursors in the current session only. It is not normally possible to see bind variable values for open cursors in other sessions because the data is private to each session - only the bind metadata is shared. You can post an event to a session to make it dump the information to its trace file, either immediately using the processstate dump at level 2, or continuously using event 10046 at level 4, but this may not be what you were after.

How does one find what values are assigned to bind variables during runtime? If you look in v$sqlarea, or the trace file, you only see the bind variable, not the actual value. I want to find out what value gets assigned to the bind variable during runtime.