oracle一分钟内执行的脚本
oracle一分钟内执行的脚本Java代码--一分钟内执行的脚本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