| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** can two processes use the same rollback extent
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
<Daniel.Fink_at_S To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
un.COM> cc:
Sent by: Subject: Re: ** can two processes use the same rollback extent
ml-errors_at_fatc
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: Rajesh.Rao_at_jpmchase.com
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: ListGuru_at_fatcity.com (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). Received on Wed Dec 03 2003 - 12:44:25 CST
 |
 |