EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/u03/oradata/fast_recovery_area/arc_60463_seq.0001',
OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
SELECT TABLE_NAME, OPERATION, COUNT(*)
FROM V$LOGMNR_CONTENTS
GROUP BY TABLE_NAME, OPERATION
ORDER BY 3 DESC;
DESC V$LOGMNR_CONTENTS
EXECUTE DBMS_LOGMNR.END_LOGMNR();