oracle分析日志Oracle分析日志.doc

oracle分析日志（Oracle分析日志）
A LogMiner analysis, how to explain
From the current point of view, the analysis method is to ufor the columns in the table, the corresponding column in the table is the arrangement serial number: COL 1, COL 2), so in order to make the statement SQL LogMiner reconstructed easy identification, we need to put these numbers into the corresponding name, which need to use the data dictionary (also said LogMiner itself can be without a data dictionary, the analysis process is shown in the following), using DBMS_LOGMNR_D. BUILD (LogMiner) the process to extract data dictionary information.
LogMiner contains two PL/SQL packages and several views:
1, the dbmslogmnrd package, this package includes only a procedure for extracting data dictionary information,
Dbms logmnr d. build (process).
the dbmslogmnr package, it has three processes:
Addlogfile (name VARCHAR2, options number)
To add / delete the log file for analysis:
Startlogmnr (startsen number, endsen number, starttime number, end time number,
Dictfilename VARCHAR2, options number)
To open the log analysis,
At the same time to determine the data dictionary information on the time window and confirm whether the use of /SCN extract.
(endlogmnr)
-used to terminate the conversation analysis, it will recover the memory LogMiner.
LogMiner related data dictionary.
v$1ogmnr dictionary, LogMiner may use the data dictionary information,
Because LOGMNR can have more than one dictionary file, this view is used to display this information.
v$logmnr_parameters, the LogMiner parameter information set.
v$logmnr_logs, for the analysis of the current log list.
v$logmnr_contents log analysis results.
Two, 0racle9i LogMiner enhanced:
1, support more data / storage type: transfer line, link / CLUSTER operations, DIRECT PATH insertion and DDL operation. In the V$LOGMNR_CONTENTS SQL_REDO DDL can be seen in the operation of the original sentence (CREATE except USER, the password will appear in encryp