Podemos consultar el valor que toman las variables bind, de una consulta que se está ejecutando, y de la cual conocemos su hash_value.
select sbm.*
from v$sql_bind_metadata sbm, v$sql s, v$session vs
where vs.sid = &sid
and vs.sql_address = s.address
and s.address = sbm.address;
from v$sql_bind_metadata sbm, v$sql s, v$session vs
where vs.sid = &sid
and vs.sql_address = s.address
and s.address = sbm.address;
col sql_id format a13
col Name format a5
col position format 99
col datatype format 99
col datatype_string format a14
col character_sid format 9999
col was_captured format a3
col last_captured format a20
col value_string format a30
–***********************************************
Select Sql_Id,
Name,
Position,
Datatype,
Datatype_String,
Character_Sid,
Was_Captured,
Last_Captured,
Value_String
From V$sql_Bind_Capture
Where Hash_Value = ‘&hash’
col Name format a5
col position format 99
col datatype format 99
col datatype_string format a14
col character_sid format 9999
col was_captured format a3
col last_captured format a20
col value_string format a30
–***********************************************
Select Sql_Id,
Name,
Position,
Datatype,
Datatype_String,
Character_Sid,
Was_Captured,
Last_Captured,
Value_String
From V$sql_Bind_Capture
Where Hash_Value = ‘&hash’
Sobre el valor que toman las variables bind en una consulta SQL por Gisela Velazco se encuentra bajo una Licencia Creative Commons Atribución-NoComercial-SinDerivadas 3.0 Unported.