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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 17 00:34:15 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.