1 运行下面脚本:
conn /as sysdba

@$ORACLE_HOME/rdbms/admin/dbmslm.sql
@$ORACLE_HOME/rdbms/admin/dbmslmd.sql
@$ORACLE_HOME/rdbms/admin/dbmslms.sql

2 创建数据字典文件(data-dictionary)--Extracting the Dictionary to a Flat File
CONNECT /as sysdba

alter system set UTL_FILE_DIR ='/u01/oracle/oradata/' scope=spfile;

shutdown immediate                                  

startup 重新启动数据库，使新加的参数生效，然后创建数据字典文件：

EXECUTE dbms_logmnr_d.build('dictionary.ora', '/u01/oracle/oradata/');

3 创建要分析的日志文件列表
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo02.log', dbms_logmnr.new);
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo01.log', dbms_logmnr.addfile);
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo03.log', dbms_logmnr.addfile);

4 使用logminer进行日志分析
EXECUTE dbms_logmnr.start_logmnr( DictFileName=>'/u01/oracle/oradata/dictionary.ora');

5 查看某个对象的操作历史
select operation, count(*) from v$logmnr_contents  where seg_name='TEST' group by operation;