Today I have been experimenting with the new feature of continous mining with logmnr.
- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
- ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
or we don't see the funny things in the redologfiles
I now starts the logminer session in one window with :
[code]
BEGIN
dbms_Logmnr.Start_Logmnr(StartTime => SYSDATE - 1 / 24, Options => dbms_Logmnr.dict_From_OnLine_Catalog + dbms_Logmnr.Continuous_Mine);
END;
/
SELECT *
FROM v$Logmnr_Logs;