Good day,

I'm currently busy with a physical database design for a DSS db. The relevant data mart estimate size is +- 60G. I'm now planning the rollback segments, but get inconsistent information from documentation.

I read in different documents to have 4 rollback segments per concurrent transaction and rollback segment size should be 10% of largest table, etc.

In document "How to stop decrementing and start living" the author suggests a rollback table space should have between 1024 and 4096 extents with between 1/8 and 1/16 of extents as number of rollback segments in table space.

What is the ideal solution?

Thanks
Johan