Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Why does it take so long to write archive logs

Why does it take so long to write archive logs

From: Rodrigues, Bryan <>
Date: Mon, 07 Jul 2003 15:11:44 -0700
Message-ID: <>

Hello everyone,

We have an on HP-UX 11.0 OPS database that uses 200mb archive logs with 3 archive log destinations, the first destination is local to the machine which is mandatory, the second destination is a filesystem accessible via nfs which is optional and the third destination is a remote standby database accessible via a vpn which is also optional. We have 10 archive processes to take care of the writing of the archives. Both the local destination and nfs mounted filesystems are on a HP XP256 storage device.

This morning there was a process running that would update a table that is used for a catalog of parts. The process was producing archive logs, but the archives were taking around 10 minutes to write. During the process we would see the file created with the expected byte count of the file within the first minute, but the timestamp of the file would indicate access for the next ten minutes.

We have two other 8.1.7 databases that are setup in a similar manner (that are not OPS) that have 2 destinations, one local and the other being sent to a remote standy database. We are not seeing the same type of issue with the archive logs.

Can someone point me in the direction of either information or advice about why the archives may be taking so long to write?

Is it that we have 3 destinations and it waits until all 3 destinations are taken care of?

Why does the archive log file appear to be modified even though the byte count hasn't changed?

TIA, Bryan Rodrigues
Elcom, Inc.
Oracle DBA

Please see the official ORACLE-L FAQ:

Author: Rodrigues, Bryan

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 07 2003 - 17:11:44 CDT

Original text of this message