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

[rahul sharma]

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