sql 抓取脚本

select *
     from  v$sql s
where s.last_active_time >
            (select sysdate-1/24/60/60*8 from dual)
        and s.last_active_time <
              (select sysdate-1/24/60/60*1 from dual)
        and s.executions >0
        and s.executions <100
        and s.parsing_schema_name='数据库名';

select * from v$sql_bind_capture t where t.sql_id='xxxxx';

转载于:https://www.cnblogs.com/vicky24k/p/4459792.html