Finding the values of Query bind variables (Oracle 10g)
This is a nice feature that is made available in Oracle 10g. if you run a query using bind variable, it is not easy task to trace back what value were there when the query was executed.
For tracing, troubleshooting and tuning exercises, it can become really important to know the actual values that the query was using. For example
Select * from EMP where empno =:B1
You could find such statements in trace files and SQL_AREA
sql_id, t.sql_text SQL_TEXT,
from v$sql t join v$sql_bind_capture b -- do not worry, just normal join
b.value_string is not null
and sql_id ='3387zvbvz48qd'
you can get sql_id from v$sqlarea