DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007

    Logminer not showing recent actions

    I basically follow this procedure:
    The logminer-package is already compiled.
    I add the logfiles (adding all with dbms_logmnr.add_logfile())
    Then I start the logminer - typically dbms_logmnr.start_logmnr(options => dbms_logmnr.dict_from_online_catalog + dbms_logmnr.print_pretty_sql)

    I do a search through v$logmnr_contents and find the expected.

    Now I do some inserts, updates and deletes. Should I expect them to show up when searching v$logmnr_contents or do I have to "start" the logminer again?

    Here's my problem:
    Even if I do restart the logminer (stop it, then start it again), the new inserts, updates and deletes mentioned above do not show in v$logmnr_contents. It still just contains the old ones. Some statements from the 18th, for instance.

    Will they only show after a while? Or what is going on here?

    The code I am using (run one by one, not as a script):
    grant execute_catalog_role to system
    create public synonym dbms_logmnr for sys.dbms_logmnr
    select distinct member logfilename from v$logfile
    execute sys.dbms_logmnr.START_LOGMNR(options => sys.dbms_logmnr.dict_from_online_catalog + sys.dbms_logmnr.print_pretty_sql);
    select username, to_char(timestamp,'dd/mm/yyyy hh24:mi:ss') timestamp, seg_type_name, table_name, table_space, session# SID, serial#, sql_undo, sql_redo
    from v$logmnr_contents where table_name='RAB_TEST';
    Thank you for any help.

  2. #2
    Join Date
    May 2005
    AZ, USA

  3. #3
    Join Date
    Sep 2007
    Thanks, but this isn't really helping. If you mean "try continuous mine", I have, but I do not get results from it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.