查询执行过的sql语句的方法

select * from v$sql where lower(sql_text) like '%gcfw_framework%' and last_active_time　 > sysdate - 1/24;

select * from v$sql where upper(SQL_FULLTEXT) like '%DELETE%GCFW_FRAMEWORK%'

  select * from gv$sql where sql_id = '0ms8nx15as157';

 
 
select
*
from 
   dba_hist_sqlstat s,
   dba_hist_snapshot sn
where 
   sn.begin_interval_time > trunc(sysdate) - 10
--and 
--   to_date('2016-09-19 05:00', 'yyyy-mm-dd HH24:mi')
and
   sn.snap_id=s.snap_id
   and s.sql_id = 'ayr7hs2262jj2'
order by s.instance_number, begin_interval_time;


http://blog.itpub.net/7607759/viewspace-445628