日期:2014-05-16 浏览次数:20432 次
--一分钟内执行的脚本 select * from v$sqlarea t where t.PARSING_SCHEMA_NAME like '%ESB_STATISTICS%' and t.LAST_ACTIVE_TIME>=sysdate-interval '1' MINUTE order by t.LAST_ACTIVE_TIME --一分钟内插入与修改的脚本 select * from v$sqlarea t where t.PARSING_SCHEMA_NAME like '%ESB_STATISTICS%' and (upper(t.SQL_TEXT) like '%INSERT%' or upper(t.SQL_TEXT) like '%UPDATE%') and t.LAST_ACTIVE_TIME>=sysdate-interval '1' MINUTE