I do regular updates on the entire database and I was told that increasing the rollback segment could speed up the process.
Is that true?
What exactly does the rollback segment do and what is it used for?
Is it true that increasing the rbs datafile size would increase the rollback segment size or do I need to specify elsewhere of the rollback segment.
And does increasing the rbs datafile size mean increasing the rollback segment size?
Thanks.