oracle 一分钟内执行的脚本
--一分钟内执行的脚本select * from v$sqlarea t where t.PARSING_SCHEMA_NAME like '%ESB_STATISTICS%' and t.LAST_ACTIVE_TIME>=sysdate-interval '1' MINUTEorder 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
