Need help with redo log writer

From: Flyfish <d_at_deja.com>
Date: Thu, 17 Jan 2002 12:02:51 -0500
Message-ID: <MPG.16b0cda77da9090f989686@News.CIS.DFN.DE>

I have a DSS system on a HP9000 (K 460) running HPUX 11.0, Oracle 8.1.6.0.

Redo log write time is "high" per Spotlight on Oracle monitoring. Averages between 60-120+ ms.

Redo logs are on a striped logical (3 physical drives, 10K rpm scsi-2) volume with low disk I/O according to sar (7-10% utilized)

The redo buffer is set to 1536K.

The database is not in archivelog mode.

What can I do to reduce the redo log write time? Would increasing or decreasing the size of the redo log buffer have any impact?

thanks in advance

Dave Bottom
dave_l_bottom AT keane-nne DOT com Received on Thu Jan 17 2002 - 11:02:51 CST