例1:查询对TEST表进行查询的历史sql
select * from v$sqlarea t
where t.SQL_TEXT like'%SELECT%FROM TEST%' order by t.LAST_ACTIVE_TIME desc
例2:查询用户TRUI对TEST表进行更新的历史sql
select * from v$sqlarea t
where t.PARSING_SCHEMA_NAME in ('TRUI')
AND SQL_TEXT like'%UPDATE TEST%' order by t.LAST_ACTIVE_TIME desc
例3:查询用户TRUI对2021/6/28之后对TEST表进行删除的历史sql
select * from v$sqlarea t
where t.PARSING_SCHEMA_NAME in ('TRUI')
AND SQL_TEXT like'%DELETE FROM TEST%'
AND LAST_ACTIVE_TIME>=to_date('2021-06-28','yyyy-mm-dd')
order by t.LAST_ACTIVE_TIME desc