Oracle日志挖掘配置-优快云博客

本文详细介绍了在Oracle数据库中配置并使用日志挖掘功能的过程，包括设置文件目录、创建及启动日志挖掘任务等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> conn /as sysdba
Connected.
SQL> show parameter utl
SQL> @?/rdbms/admin/dbmslm.sql
Package created.
Grant succeeded.
SQL> @?/rdbms/admin/dbmslmd.sql
Procedure created.
No errors.
Grant succeeded.
PL/SQL procedure successfully completed.
Package created.
SQL> alter system set utl_file_dir='/oracle/304/arch' scope=spfile;
System altered.
SQL> shutdown immediate
SQL> startup
SQL> execute dbms_logmnr_d.build ('test.ora','/oracle/304/arch');
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.add_logfile (logfilename=>'/oracle/304/arch/inst933/arch_1_507.arc',options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.add_logfile (logfilename=>'/oracle/304/arch/inst933/arch_1_508.arc',options=>dbms_logmnr.addfile);
PL/SQL procedure successfully completed.
SQL> execute dbms_logmnr.start_logmnr(dictfilename=>'/oracle/304/arch/test.ora');
PL/SQL procedure successfully completed.
SQL> desc v$logmnr_contents
SQL> execute dbms_logmnr.end_logmnr;[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10897379/viewspace-964916/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10897379/viewspace-964916/