如果发现归档日志暴增的情况,可以通过Logminer去分析归档日志、Awr报告去查看DML操作,还可以通过SQL直接查询哪些DML操作:
select * from dba_tab_modifications where timestamp > sysdate - 2 and table_owner in ('XXX','YYY') order by timestamp desc