Rollback Segment Calculation - Response

You will also need to size you Temp space if you are doing sorts. Particularly if you are working with a table that size. My rule of thumb is to size my rollback tablespace so that two of my largest tables can fit into it. I would size my segments to be able to extend through a little over half of the size of the tablespace (rollback). My TEMP tablespace should be able to hold a sort equal to size of two of my largest tables. The default table extents should be sized so that it can extend throughout the entire tablespace. As for the algorithm necessary to determine the size, I would just look at the size of the table.

Sheilah Scheurich
Dimension Systems Inc
DBA My opinion are my own and not that of my employer. Received on Thu Feb 06 1997 - 00:00:00 CST