You can increase the size of initial and next but you will have to drop and recreate the rollbacksegments.
OPTIMAL depend on, to what size you want to maintain your rollback segments to avaiod dynamic allolcation of extents.
Keep in mind..
INITIAL=NEXT and OPTIMAL > MINEXTENTS*INITIAL
Sanjay




Reply With Quote