Log Miner

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();