Re: ** can two processes use the same rollback extent

From: rahul sharma <rahul_at_infotech.co.id>
Date: Tue, 02 Dec 2003 19:59:26 -0800
Message-ID: <F001.005D8732.20031202195926@fatcity.com>

i can answer the first part of your question..

YES, two transactions can write on the same extent of an RBS, i think the restriction is at the block level,

this was true until 8i, might have changed in 9 +

----- Original Message -----

From: A Joshi

To: Multiple recipients of list ORACLE-L

Sent: Wednesday, December 03, 2003 9:09 AM

Subject: ** can two processes use the same rollback extent

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

Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: rahul sharma
  INET: rahul_at_infotech.co.id

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 Tue Dec 02 2003 - 21:59:26 CST