Oracle uses Logminer profiling redo log files All steps (WINDOWS NT Chinese VERSION)

Oracle|window Oracle installed on disk D:
1. Re-establish the Pl/sql package Dbms_logmnr_d
Open D:\oracle\ora81\rdbms\admin\dbmslmd.sql
Find
"TYPE Col_desc_array is Varray (513) of col_description;"
To
"TYPE Col_desc_array is Varray (1023) of col_description;"
Execute the following command in Server Manager
Svrmgr>@d:\oracle\ora81\rdbms\admin\dbmslmd.sql
2. Set initialization parameter Utl_file_dir, add a row in the parameter file:
Utl_file_dir=d:\oracle\oradata\manu
Restart database
3. Execute the following command to create a dictionary file
Svrmgr>execute DBMS_LOGMNR. Build (
' V817dict.dic ', ' D:\oracle\oradata\manu ');
4. Add redo log files to be analyzed
Svrmgr>execute DBMS_LOGMNR. AddFile (
' D:\oracle\oradata\manu\redo10.log ', DBMS_LOG_MNR. NEW);
Svrmgr>execute DBMS_LOGMNR. AddFile (
' D:\oracle\oradata\manu\redo20.log ', DBMS_LOG_MNR. AddFile);
5. Start analysis
Svrmgr>execute DBMS_LOGMNR. START_LOGMNR (
Dictfilename=> ' D:\oracle\oradata\manu\v817dict.dic ');
6. Query V$logmnr_contents View
Svrmgr>select * from V$logmnr_contents;
7. Stop Analysis
Svrmgr>execute DBMS_LOGMNR. END_LOGMNR;