Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with redo log writer
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