Re: multiple transaction in same extent of one rollback segment

From: Stephan Bressler <agadir_at_web.de>
Date: Tue, 28 Aug 2001 14:29:25 +0200
Message-ID: <9mg2rd$cp9$1@news.mch.sbs.de>

Hi,

several transaction may share the same extent, but each block is used by one transaction exclusively.

Regards
Stephan

"Yerong" <yhe_at_challengerint.com.au> schrieb im Newsbeitrag news:3fd9ab19.0108272231.6514db1b_at_posting.google.com...
> Hi,
> Multiple transaction can write to the same extent of a
> rollback segment. But can they do this at the same time?
>
> I ask this question because according to the Oracle training
> manual:
> "when an extent in a rollback segment is filled up, the Oracle
> server attempts to reuse the next extent in the ring. But if
> this new extent contains one active entry, i.e. an entry
> that was written by a transaction that is still active, it can
> not be used, it need to allocate an addtional extent."
>
> Please advise.
>
> Thanks/yerong
Received on Tue Aug 28 2001 - 07:29:25 CDT