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

[A Joshi]

Hi,

  A simple rollback segment question. If I do not set a optimal then can I assume following

 

1)  rollback segment will not shrink.

2) It will keep growing till tablespace fills up.

3) And there will be no 'snapshot too old' errors?

 

Thanks

A Joshi <[EMAIL PROTECTED]> 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

---

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