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

[Daniel Fink]

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
 
 

---

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