Pl/SQL tracing

[PAVB]

If properly setup no trace is needed.

Use query below plugging in hash_value...

select  c.name                      BIND, 
        substr(c.value_string,1,25) VAL
from    v$sqlarea a, 
        v$sql_bind_capture c
where   a.sql_id = c.sql_id 
and     a.hash_value = 'hash_value'
order by a.last_active_time desc, c.name asc
;