Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with redo log writer

Re: Need help with redo log writer

From: koert54 <koert54_at_nospam.com>
Date: Fri, 18 Jan 2002 12:33:16 GMT
Message-ID: <gCU18.79385$rt4.5583@afrodite.telenet-ops.be>


if you want performce - move your redo to raw devices ...

"Flyfish" <d_at_deja.com> wrote in message
news:MPG.16b0cda77da9090f989686_at_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 Fri Jan 18 2002 - 06:33:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US