Hi all
We have rollback contention determined after queyring v$rollname and v$rollstat.
We are showing rollback segments as following:
RBS01 INITIAL =524288
NEXT =524288
MIN EXTENTS= 8
MAX EXTENT=32765
AND no OPTIMAL specified.
I would like to increase the size of the INITIAL & NEXT and set MINEXTET to 20.
Our db_block_size is 8196.
Can I increase initial and next by just multiplying their respective value to 2 to have large rollback segments?
EX= INITIAL =(524288 x2)=1048576
NEXT =(524288x2)= 1048576
MINEXTENT = 20
MAXEXTENT =??????? (Considering the figure what value may give to maxextent and Optimal?
OPTIMAL =???????
Total rollback segment online 34.
After creation of all the big rollbacks I will bring them all online and take all the little offline and drop then right?
Please advise
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.