由 macro 发布于: 2001-03-04 15:53

Initialize a LogMiner session:

EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME=>'C:\ora815\oradata\v815\log\v815dict.ora');


Tracking Changes to a table
eg.
SELECT timestamp,username,sql_redo FROM v$logmnr_contents WHERE seg_name='EMP';

Finish the logMiner session:

EXECUTE DBMS_LOGMNR.END_LOGMNR;


Obtaining Information About Logs Being Analyzed
Once LogMiner has been started ,the following data dictionary views can be used:

1.v$logmnr_dicationary
2.v$logmnr_parameters
3.v$logmnr_contents
__________________

谢谢你抽时间看我的发言，

Macro Zeng

==================================

我正在学习 Oracle ,坚持每天写读书笔记