1）DML最后时间和操作记录条数
all_tab_modifications;
http://blog.itpub.net/28211342/viewspace-2141347/
2）数据库操作语句
v$session a, v$sqlarea b,v$session_longops c
https://blog.csdn.net/weixin_42471823/article/details/116358863
select distinct
t.TABLE_OWNER,
regexp_replace(
regexp_replace(regexp_replace(regexp_replace(t.table_name,'5[7-8][0-9]','XXX'),
'20[0-9]{2}[0-1][0-9][0-3][0-9]','YYYYMMDD'),
'20[0-9]{2}[0-1][0-9]',
'YYYYMM'),
'20[0-9]{2}',
'YYYY') AS en_name
from all_tab_modifications t
where t.table_owner='ZJSJYYT'
and to_char(t.timestamp, 'YYYYMMDD') >= '20220605'
and t.inserts > '0'
and table_name not like '%TEMP%'
and table_name not like '%TMP%'
and table_name not like '%BAK%'
and table_name not like '%TEST%';
