This section describes the steps in a typical LogMiner session. Each step is described in its own subsection.
To run LogMiner, you use the DBMS_LOGMNR PL/SQL package. Additionally, you might also use the DBMS_LOGMNR_D package if you choose to extract a LogMiner dictionary rather than use the online catalog.
The DBMS_LOGMNR package contains the procedures used to initialize and run LogMiner, including interfaces to specify names of redo log files, filter criteria, and session characteristics. The DBMS_LOGMNR_D package queries the database dictionary tables of the current database to create a LogMiner dictionary file.
The LogMiner PL/SQL packages are owned by the SYS schema. Therefore, if you are not connected as user SYS, then:
You must include SYS in your call. For example:
EXECUTE SYS.DBMS_LOGMNR.END_LOGMNR;
You must have been granted the EXECUTE_CATALOG_ROLE role.
Oracle Database PL/SQL Packages and Types Reference for details about syntax and parameters for these LogMiner packages
Oracle Database Development Guide for more information about PL/SQL packages