DBMS LOGMNR

DBMS_LOGMNR is a PL/SQL package used to extract contect from Oracle redo log files.

Example

Simple example:

EXECUTE DBMS_LOGMNR.START_LOGMNR( -
   STARTTIME => SYSDATE-1/24, -
   ENDTIME => SYSDATE+1/24, -
   OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + -
   DBMS_LOGMNR.CONTINUOUS_MINE);

select USERNAME, OPERATION ,SQL_REDO from v$logmnr_contents;