Try increasing the log_buffer to 5M
"koert54" <koert54_at_nospam.com> wrote in message news:<gCU18.79385$rt4.5583_at_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 - 19:21:59 CST
