oracle 历史记录查询sql
SELECT t.SQL_TEXT, t.FIRST_LOAD_TIME, t.SQL_FULLTEXT
FROM v$sqlarea t
WHERE t.FIRST_LOAD_TIME LIKE '2020-03-20/17:0%' -- 根据时间匹配
AND t.SQL_FULLTEXT NOT LIKE '%SELECT t.SQL_FULLTEXT, t.FIRST_LOAD_TIME%'
AND t.SQL_FULLTEXT NOT LIKE '%INSERT INTO LOG%'
ORDER BY t.FIRST_LOAD_TIME DESC;