Skip to content

Instantly share code, notes, and snippets.

@davidhooey
Created April 9, 2018 19:47
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davidhooey/76b238157ea03966e891c4fb640b77e1 to your computer and use it in GitHub Desktop.
Save davidhooey/76b238157ea03966e891c4fb640b77e1 to your computer and use it in GitHub Desktop.
List values used for bind variables from single SQL_ID.
select
snap_id,
sql_id,
name,
position,
datatype_string,
to_char(last_captured,'YYYY-MM-DD HH24:MI:SS') last_captured,
value_string
from
dba_hist_sqlbind
where
sql_id = 'SQL_ID'
and
value_string is not null
order by
snap_id,
last_captured,
position;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment