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 -> multiple transaction in same extent of one rollback segment

multiple transaction in same extent of one rollback segment

From: Yerong <yhe_at_challengerint.com.au>
Date: 27 Aug 2001 23:31:52 -0700
Message-ID: <3fd9ab19.0108272231.6514db1b@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 - 01:31:52 CDT

Original text of this message

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