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: undo header and buffer busy wait

Re: undo header and buffer busy wait

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 15 Feb 2002 13:52:57 +1100
Message-ID: <1013741618.970613@bugstomper.ihug.com.au>


More rollback segments. Bigger rollback segments. And get rid of optimal.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.1013722665.1895874023@[64.94.198.252]...

> We are using 8.1.7.2 on solaris.
> We have usually 20 sessions, and we have 13 rollback segs, each one
> with 50k initial, with optimal set to 500k. Even though, we still get
> a lot of undo header wait and the buffer busy wait is always on
> rollback tablespace, how should I do to improve it?
>
> Our I/O wait from top command shows we have constantly 5 to 10%
>
> Thanks
>
>
>
>
>
> --
> Sent by dbadba62 from hotmail included in com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Feb 14 2002 - 20:52:57 CST

Original text of this message

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