DBA_LOGMNR_DICTIONARY_BUILDLOG describes all successful LogMiner dictionary builds available for GoldenGate REGISTER EXTRACT.

If you encounter SYS.LOGMNR_AUTO_DICTIONARY_BUILD, treat it as an internal Oracle object. Do not modify, truncate, drop, or use it as an application dependency.

For monitoring, use the supported data dictionary view:

SELECT name,
       date_of_build,
       start_scn,
       end_scn,
       build_type,
       build_op,
       container_name
FROM   dba_logmnr_dictionary_buildlog
ORDER BY start_scn DESC;

To check archived redo for dictionary-build markers:

SELECT sequence#,
       first_change#,
       next_change#,
       completion_time,
       dictionary_begin,
       dictionary_end
FROM   v$archived_log
WHERE  dictionary_begin = 'YES'
   OR  dictionary_end   = 'YES'
ORDER BY first_change# DESC;

Use DBA_LOGMNR_DICTIONARY_BUILDLOG to review completed builds and V$ARCHIVED_LOG to confirm dictionary markers in archived redo.

References:

• DBA_LOGMNR_DICTIONARY_BUILDLOG
• V$ARCHIVED_LOG