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: Sat, 16 Feb 2002 08:08:06 +1100
Message-ID: <1013807330.659263@bugstomper.ihug.com.au>


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]...

> 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
Received on Fri Feb 15 2002 - 15:08:06 CST

Original text of this message

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