Finding All Modifications in the Last Archived Redo Log File By using LogMiner

SELECT NAME FROM V$ARCHIVED_LOG
WHERE FIRST_TIME = (SELECT MAX(FIRST_TIME) FROM V$ARCHIVED_LOG);


EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/oradata2/archive/arch1_1328_1_664408221.dbf',OPTIONS => DBMS_LOGMNR.NEW);


EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);


SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID,
SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS WHERE username IN ('SADAT');