Tips for Rollback Segments

- The usage of SYSTEM tablespace for the rollback segments should be avoided. Create a separate tablespace for the rollback segments.
- Create approximately one rollback segment for every four concurrent transactions expected.
- The large rollback segments should be assigned for the long-running queries and setting the storage parameter 'OPTIMAL' appropriately
- The dynamic expansion and reduction of rollback space can be avoided by monitoring the rollback information using dynamic views.