Unable to archive log / database hang
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Unable to archive log / database hang

  1. #1
    Join Date
    Nov 2002
    Location
    Columbia, sc
    Posts
    9

    Unable to archive log / database hang

    First off, Oracle 8.1.7.4 on Solaris 8...

    During a moderately heavy load, the database sent the "Failed to archive log" message to the alert log. I understand that this is an informational message and can be ignored. But the issue is that around the time that this message appeared in the alert log, the database seemed to hang. Logins would take up to 30 seconds and active sessions would stall. I think the problem is with I/O contention with the redo logs and the archive log processes as they are on the same physical drives. The Log File Sync wait event is relatively high compared to the other wait events ( ~ 400ms/sec peak ).

    Can anyone confirm my theory, offer an alternative reason for this behavior or point me to some other reasons? Thanks,

    John

  2. #2
    Join Date
    Jan 2003
    Posts
    78
    The key to understanding what is delaying 'log file sync' is to compare average times waited for 'log file sync' and 'log file parallel write':

    * If they are almost similar, then redo logfile I/O is causing the delay and the guidelines for tuning it should be followed.

    * If 'log file parallel write' is significantly different i.e smaller, then the delay is caused by the other parts of the Redo Logging mechanism that occur during a COMMIT/ROLLBACK (and are not I/O-related). Sometimes there will be latch contention on redo latches, evidenced by 'latch free' or 'LGWR wait for redo copy' wait events.
    HTH.
    Shripad Godbole
    OCP DBA (8,8i,9i)

    "Let's document it and call it a feature."

  3. #3
    Join Date
    Nov 2002
    Location
    Columbia, sc
    Posts
    9
    Thanks, you help is greatly appreciated. I will follow up on your advice.

    John

  4. #4
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    Check box to see if archived directory is 100% full.

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