And to further refine that statement and IIRC, a transaction will not use
an extent E, that already has an active transaction in it, when the
transaction has filled up the previous extent S, and is now looking to wrap
into a new extent E. However, a fresh transaction can always be allocated
space in an extent that already has an active transaction in it.
Regards
Raj
Daniel Fink
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
un.COM> cc:
Sent by: Subject: Re: ** can two processes use the
same rollback extent
[EMAIL PROTECTED]
ity.com
12/03/2003
12:04 PM
Please respond
to ORACLE-L
IIRC, a segment will not wrap into an extent that has an active transaction
in it, but rather allocate a new extent. So the answer is...it depends.
Daniel Fink
A Joshi wrote:
Hi,
One rollback segment can be used by multiple
transactions/processes but what about the extents? Is it safe to
assume that only one transaction/process can use one extent? What is
a good way to size the extent for warehousing tasks? Or guess the
rollback generated and size needed.
Thank You
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
