Hi Friends..

Many Thanks for your replies..

The reason I have 25 rollback segements is based upon the calculation : Transactions/Max Trans per rollback Segment = 125/5.

After speaking to this 'senior???' he told me that he wanted them increased due to Dr.Watson Errors when executing a large batch transaction ???. I told him to get in touch with the application vendor as this was more an MS memmory management issue, which by the way is not fixed in W2k and probably not fixed in WindowsXP.

I told him that surely Oracle would omit an ORA-XXXX error message if rollback storage parameters/space was being reached and there was nothing in the alert.log to say that there was problem and no such message appeared on screen, but he did not believe me. I therefore proved it to him by putting a trace on the session running the transaction and showed him the trace file. I still don't think he is convinced.. I think he needs a dba course.

At least now I know I need to set an optimal setting, can this be done with the following command :

ALTER ROLBACK SEGMENT R01 STORAGE (OPTIMAL 20MB)

Oracle 8.1.6

Thanks

Suresh