internal statements from v$logmnr_contents
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: internal statements from v$logmnr_contents

  1. #1
    Join Date
    Nov 2007
    Posts
    10

    internal statements from v$logmnr_contents

    Hello
    When i mine from v$logmnr_contents i get some oracle internal statements like
    select * from "SYS"."DUAL" where ROWID = 'AAAADeAABAAAAZSAAA' for update;

    update "SYS"."SEQ$" set "INCREMENT$" = '1', "MINVALUE" = '1', "MAXVALUE" = '99999999999999999999', "CYCLE#" = '0', "ORDER$" = '0', "CACHE" = '20', "HIGHWATER" = '73', "AUDIT$" = '--------------------------------', "FLAGS" = '0' where "INCREMENT$" = '1' and "MINVALUE" = '1' and "MAXVALUE" = '99999999999999999999' and "CYCLE#" = '0' and "ORDER$" = '0' and "CACHE" = '20' and "HIGHWATER" = '53' and "AUDIT$" = '--------------------------------' and "FLAGS" = '0' and ROWID = 'AAAABDAABAAAAHzAAb';

    Why such statements are coming and how do i avoide it? It wont popup every time.

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Because after all, that is redo data. It may help to read
    Querying V$LOGMNR_CONTENTS for Redo Data of Interest.

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