How to get the bind values of a sql query

SELECT
  sql_id,
  b. LAST_CAPTURED,
  t.sql_text sql_text,  
  b.HASH_VALUE,
  b.name bind_name,
  b.value_string bind_value
FROM
  gv$sql t
JOIN
  gv$sql_bind_capture b  using (sql_id)
WHERE
  b.value_string is not null  
AND
  sql_id='&sqlid'
/

Comments

Popular posts from this blog

Oracle Architecture SGA

FRA Usage and Administration

Format Date in Oracle Database - NLS_DATE_FORMAT