Recreate the Rollback Segments with a bigger MIN_EXTENTS. Oracle recommends
a MIN_EXTENTS of 20. Rollback segments are used in a circular fashion and
if a transaction commits, the segment is marked as re-usable. By making
bigger rollback segs you increase the time it takes until the segment is
actually reused. Check the manuals under "Read Consistancy".
Kenny Gump
OCP 7.3 DBA
D Huynh wrote in message ...
>I have a test application that opens a table, goes thru a loop and
>inidividually updates each of the 2 millions records. About 500,000
records
>into the run, the above error (Rollback segment too small) occurs and the
>apps terminates.
>
>I've expanded the rollback segment table space, expanded each individual
>rollback segment with a unlimited number of extends (each extends is set to
>125 data blocks).
>
>I shut down and restart the instance, and event try to reboot the manchine,
>but the rollback segments seem to stay at .293 Mb (300kb). And the program
>still faileds.
>
>I know that a real app is not supposed to perform that many trans with
>explicitly committing them, but how can I make the rollback segment bigger
>so that my test app won't fail.
>
>
>TIA.
>
>
Received on Mon Jan 11 1999 - 07:20:41 CST