v$sql_bind_capture - value of BIND_STRING changed

Hi,

In order to find out the value of a bind variable for a particular SQL in our 10.2.04 database, we used the following code

select
sql_id,
b.name BIND_NAME,
b.value_string BIND_STRING,
t.plan_hash_value,
t.last_active_time,
t.last_load_time
from
v$sql t
join v$sql_bind_capture b
using (sql_id)
where
b.value_string is not null
and sql_id='8xq6axhzh9c3x'
/

** Please note that we had flushed the shared pool prior to re-starting the application


The above query gave us the following results



SQL_ID        BIND_NAME       BIND_STRING     PLAN_HASH_VALUE LAST_ACTIVE_TIME   LAST_LOAD_TIME