Hi,
I see that there is no contention for the rollback segments.But I must tell you that there are 2 rollback segments having extent sizes of 56K each and having 348 and 330 extents respectively.

I think such a high number of extents will have an impact on performance.

What should I do do fix this and also how do I determine the optimal size of the rollback segments.

I know that you have to set a low optimal value for small transactions and high for high transactions. But shouldnt I increase the rollback segment size and set the optimal to the current usage as thats the maximum it has been used.

Please suggest.

Thanks
Anurag