CODE EXAMPLE FOR SQL

redo files log oracle

-- Show log files
select * from v$logfile;
-- Load file
EXECUTE DBMS_LOGMNR.add_logfile('/path/to/file.log');
-- Start Session
EXECUTE DBMS_LOGMNR.START_LOGMNR(
  -- Add dictionary (if not, you will get sql's like "UNKNOWN"."OBJ# and HEXTORAW('45465f4748'))
  options => dbms_logmnr.dict_from_online_catalog
);
-- Check your file 
select * from v$logmnr_contents;
-- End session
EXECUTE DBMS_LOGMNR.end_logmnr();