var current_log char( 255 )

execute select max(member) into :current_log from v$log l, v$logfile f where l.group#=f.group# and l.status='CURRENT'

execute sys.dbms_logmnr.add_logfile(:current_log, sys.dbms_logmnr.new)

execute sys.dbms_logmnr.start_logmnr(options=>sys.dbms_logmnr.dict_from_online_catalog);

drop table logmnr_test01;

create table logmnr_test01(id number primary key, value number);

begin
  for j in  1 .. 10  loop
    insert into logmnr_test01 values(j,j);
  end loop;
  commit;
end;
/


select *
from v$logmnr_contents
where seg_owner=USER
and seg_name = 'LOGMNR_TEST01'
/

begin
  for j in  1 .. 10  loop
    insert into logmnr_test01 values(j,j);
  end loop;
  commit;
end;
/