Re: undo header and buffer busy wait

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