Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: undo header and buffer busy wait
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]...Received on Thu Feb 14 2002 - 20:52:57 CST
> 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