ROLLBACK SEGMENT
Sanjay
Thank you for responding so promptly.
Considering the following
INITIAL=NEXT and OPTIMAL > MINEXTENTS*INITIAL
My new rollback segment size will be as follow.
INITIAL= 1048576
NEXT = 1048576
MINEXTENTS = 20
MAXEXTENTS =? (what's the new value?)0ld value=32765
OPTIMAL= 26214400 (ie 1048576*20*1.25)
The value of the orignal maxextent on the small rollback segment is 32765.
IS THERE ANY GUIDELINE TO INCREASE THE SIZE OF MAXEXTENTS?
And once I create the new rollback segments I will first bring them online, then take the old offline and drop them.
Can you create a new rollback segment rbs1, if you already have rbs1? or you first offline rbs1, drop it and then recreate rbs1.
Please advise.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.