Archive logs generating too quickly
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archive logs generating too quickly

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Oracle 8.1.6

    Hi Friends..

    In normal operation I generate 300 - 400Mb of archive log information a day.

    Suddenly.. overnight on Dec31 2001 this increased to 4 - 5GB of archive log information a day.

    I used logminer to see what information was being recorded and noticed thousands of internal operations with no sql redo/undo associated with them.

    Does anyone know what these operations could be ?

    Any help on this would be much apreciated.

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Try to analyze what changes have been done with Database (new functions/packages/triggers).
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks KGB..

    Found out that there was a change to the database which has caused the amount and size of transactions to increase dramatically. This has battered my rollback segments and caused Gb's of redo.

    All to do with the Euro..

    Going to hurt the developers now.



    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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