PL/SQL Packages DBMS_LOGMNR

LogMiner allows you to make queries based on actual changes made to table data. This allows you to analyze system behavior and to perform auditing tasks.

Subprocedures:

ADD_LOGFILE   Add a file to the existing or newly created list of
              archive files to process. 

START_LOGMNR  Initialize the LogMiner utility. 

END_LOGMNR    Finish a LogMiner session. 

MINE_VALUE Function
              This function may be called for any row returned from
              V$LOGMNR_CONTENTS to retrieve the undo or redo column value
              of the column specified by the column_name input parameter to this function. 

COLUMN_PRESENT Function
              This function may be called for any row returned from
              V$LOGMNR_CONTENTS to determine if undo or redo column values exist
              for the column specified by the column_name input parameter to this function. 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Views:

V$LOG V$LOGFILE V$LOGHIST V$LOGMNR_CONTENTS V$LOGMNR_DICTIONARY V$LOGMNR_LOGS V$LOGMNR_PARAMETERS V$LOG_HISTORY

Related Packages:



© Copyright SS64.com 1999-2014
Some rights reserved