25
DBMS_LOGMNR

Using LogMiner, you can make queries based on actual data values. For instance, you could issue a query to select all updates to the table scott.emp or all deletions performed by user scott. You could also perform a query to show all updates to scott.emp that increased sal more than a certain amount. Such data can be used to analyze system behavior and to perform auditing tasks.

The DBMS_LOGMNR package contains procedures used to initialize the LogMiner tool. You use these procedures to list the redo logs to be analyzed and to specify the SCN or time range of interest. After these procedures complete, the server is ready to process SQL SELECT statements against the V$LOGMNR_CONTENTS view.

This chapter discusses the following topics:

• DBMS_LOGMNR Constants
• Extracting Data Values from Redo Logs
• Example of Using DBMS_LOGMNR
• Summary of DBMS_LOGMNR Subprograms