Originally posted by tamilselvan
To avoid those error.

1. Create larger rollback segments.
2. Set minimum extents to 20 and maxextents to 500 for each rollback segment.
3. Create more number of rollback segments.

I have 8 Rollback segments RB0 .. RB7.

Following is the Extents Storage Parameter for each one of them. (I am using DBA Studio to look at them)

Initial Size = 256 KB
Next Size = 256 KB
Optimal Size = 512 KB
Minimum Number = 2 (not editable)
Maximum Number = 2147483645


The RBS Tablespace has the following Extent Storage paramater

Initial Size = 1024 KB
Next Size = 1024 KB
Minimum Number = 2 (editable)
Maximum Number = 2147483645


How do I change the Minimum extent number for the rollback segments and are these settings ok.

Please Suggest

Ronnie