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