Saturday, February 16, 2019

Get bind variable values of the application query using sql_id

SELECT t.sql_id,
  b. last_captured,
  t.sql_text sql,
  b.hash_value,
  b.name bind_name,
  b.value_string bind_value
FROM gv$sql t,
  gv$sql_bind_capture b
WHERE t.sql_id      =b.sql_id
AND b.value_string IS NOT NULL
AND t.sql_id        ='&sql_id' --'6mz9xrh5nc007'
ORDER BY b.last_captured DESC;

No comments:

Post a Comment