脚本内容
--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;
评论
贡献排行榜