You must have the
EXECUTE_CATALOG_ROLE role and the
LOGMINING privilege to query the
V$LOGMNR_CONTENTS view and to use the LogMiner PL/SQL packages.
When mining a specified time or SCN range of interest within archived logs generated by an Oracle RAC database, you must ensure that you have specified all archived logs from all redo threads that were active during that time or SCN range. If you fail to do this, then any queries of
V$LOGMNR_CONTENTS return only partial results (based on the archived logs specified to LogMiner through the
DBMS_LOGMNR.ADD_LOGFILE procedure). This restriction is also in effect when you are mining the archived logs at the source database using the
CONTINUOUS_MINE option. You should only use
CONTINUOUS_MINE on an Oracle RAC database if no thread is being enabled or disabled.
"Steps in a Typical LogMiner Session" for an example of using LogMiner