Oracle 8i analysis Tools: Logminer

Oracle Logminer is an actual, useful analysis tool that Oracle has provided from the product 8i, which makes it easy to get the details of Oracle Redo log files (archived log files), especially The tool can analyze all the DML (INSERT, UPDATE, DELETE, etc.) statements for database operations, and can also parse out some necessary rollback SQL statements. This tool is especially useful for debugging, auditing, or rollback of a particular transaction.

The Logminer analysis tool is actually made up of a set of pl/sql packages and some dynamic views (oracle8i part of a built-in package) that is released as part of an Oracle database and is a completely free tool for 8i products. However, this tool is somewhat more complex to use than other Oracle built-in tools, mainly because the tool does not provide any graphical user interface (GUI). This article describes in detail how to install and use the tool.

First, the use of Logminer

The log file holds all data for database recovery, recording every change to the database structure, that is, all DML statements that operate on the database.

Prior to Oracle 8i, Oracle did not provide any tools to assist the database administrator in reading and interpreting the contents of the Redo log files. Problems with the system, the only job you can do for a typical data administrator is to package all of the log files and then send it to Oracle for technical support, and then quietly wait for Oracle's technical support to give us the final answer. Since 8i, however, Oracle has provided such a powerful tool for-logminer.

The Logminer tool can be used to analyze the online, or to analyze offline log files, which can be used to analyze the redo log files of their own databases, or to analyze the redo log files of other databases.

Overall, the main uses of Logminer tools are:

1. Tracking database changes: You can track changes to the database offline without affecting the performance of the online system.

2. Rollback database changes: Rollback of specific change data to reduce point-in-time recovery execution.

3. Optimization and expansion plan: You can analyze data growth patterns by analyzing the data in the log file.

Second, install Logminer

To install the Logminer tool, you must first run the following two scripts,

L $ORACLE _home/rdbms/admin/dbmslsm.sql

2 $ORACLE _home/rdbms/admin/dbmslsmd.sql.

Both scripts must be run as the SYS user. The first of these scripts is used to create a DBMS_LOGMNR package that analyzes the log files. The second script is used to create the Dbms_logmnr_d package, which is used to create the data dictionary file.