show_bind_value
emcs
46次下载
371次浏览
2019-07-24
4.5

脚本内容

--yong.zhao
--from gv$
col name for a20
col bind_value for a30
select * from 
(select sql_id,
        name,
        datatype_string,
        case datatype
          when 180 then --TIMESTAMP
           to_char(ANYDATA.accesstimestamp(t.value_anydata),
                   'YYYY/MM/DD HH24:MI:SS')
          else
           t.value_string
        end as bind_value,
        last_captured
   from gv$sql_bind_capture t
  where sql_id = '&sql_id'
  order by last_captured desc,name)
  where rownum<=100
  order by last_captured,name;

--from awr
col name for a20
col bind_value for a30
select *
from (select sql_id,
        name,
        datatype_string,
        case datatype
          when 180 then --TIMESTAMP
           to_char(ANYDATA.accesstimestamp(t.value_anydata),
                   'YYYY/MM/DD HH24:MI:SS')
          else
           t.value_string
        end as bind_value,
        last_captured
   from dba_hist_sqlbind t
  where sql_id = '&sql_id'
  order by last_captured desc,name)
  where rownum<=100
  order by last_captured,name;

评论

贡献排行榜