Home » RDBMS Server » Server Administration » Rollback Segment
Rollback Segment [message #369434] Thu, 21 September 2000 09:56
Rekha
Messages: 9
Registered: September 2000
Junior Member
The table has about 1600000 rows.
It is not able to handle big transaction and I get error
ORA-01562: failed to extend rollback segment number 3

Right now I have storage settings
initial 128 k
next 128 k
maximum number 800
What would be idle storage size for rollback segments?

Thanks in advanced
Previous Topic: Truncate Table using a Procedure
Next Topic: command buffer space exhausted
Goto Forum:
  


Current Time: Thu Mar 28 07:09:55 CDT 2024