Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: undo header and buffer busy wait
There were 3 suggestions; you've tried 1 of them. What happens when you try
the other 2?
Regards
HJR
-- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.1013806002.1034759521@[64.94.198.252]...Received on Fri Feb 15 2002 - 15:08:06 CST
> Thanks for Howard J. Rogers and Mark D Powell's help.
>
> But after I make our rollback segments 10 times bigger, we are still
> get the same undo header wait event, it did not show any improvment.
>
> Our database is collecting data through robot, each second we have
> about 30 rows comming, and we are using auto committing.
>
> Actually I seldom see any transaction using rollback segment, because
> it commits so quickly. But why we are getting undo header contention?
>
> Any thoughts?
>
> thanks
>
>
>
>
>
>
> --
> Sent by dbadba62 from hotmail element from com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new