Increase the size of your rollback segments:
As a guide
'When a mix of transactions is not prevalent, each rollback segment should be 10% of the size of the databases largest table because most SQL affects 10% or less of a table'
Their words not mine!
Hope this helps
Moff




Reply With Quote