Installing logminer To install the logminer packages you need the run the scripts: $ORACLE_HOME/rdbms/admin/dbmslm.sql and $ORACLE_HOME/rdbms/admin/dbmslmd.sql. The first installs the DBMS_LOGMNR package and needs to be run on the database which you will use to analyse the logfiles. The second installs the DBMS_LOGMNR_D package which builds the data-dictionary file, and needs to be run on the database from which the redo logs are generated. Both packages need to run as SYS. Installing the packages does not grant execution rights to other users (including SYSTEM) so, unless you do so, using logminer is restricted to the SYS user.
不过logminer要上网down的
To install the logminer packages you need the run the scripts: $ORACLE_HOME/rdbms/admin/dbmslm.sql and $ORACLE_HOME/rdbms/admin/dbmslmd.sql.
The first installs the DBMS_LOGMNR package and needs to be run on the database which you will use to analyse the logfiles. The second installs the DBMS_LOGMNR_D package which builds the data-dictionary file, and needs to be run on the database from which the redo logs are generated.
Both packages need to run as SYS.
Installing the packages does not grant execution rights to other users (including SYSTEM) so, unless you do so, using logminer is restricted to the SYS user.