Abnormally high ArchLog Generation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Abnormally high ArchLog Generation

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    Yesterday I observed abnormally high no of Archlogs Generation.

    In normal cases I get around 4 GB of ArchLogs. Yesterday it crossed 30GB.

    Can I check weather there was some problem due to which this had happened or some other issue.

    Yesterday Logs were switching twice per minute also sometimes.

    My RedoLog file size is 20MB and the user are 300.

    I am running SAP on Oracle 816 / NT.

    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Same problem happened to me.

    I used logminer to see what was in the logs and narrowed it down to an object which kept cropping up in the logs.

    I sent this info to Oracle and I was told that the object had a permanent lock on it or something like that. gave this information to our application developers who were able to resolve the issue (they were the cause of the issue in the first place).

    The best thing to do is mine your log or dump it and investigate what is in them. Take it from there.

    Info on how to do this can be found on Oracle Metalink.

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

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi Suresh,

    Thanks for the reply.

    Can I make use of my other server as I don't want to do anything on my production server.

    I mean can I check these use logs on other machine.

    regds
    vijay
    --------------------------
    The Time has come ....

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    sure you can.

    You have to make sure that the dictionary file is created from the database the log file came from.

    It is all documented

    http://home.clara.net/dwotton/dba/logminer.htm
    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