Help! Failure to extend rollback segment 2 because of 1628 condition [message #51981] |
Mon, 24 June 2002 14:39 |
sheela
Messages: 66 Registered: March 2002
|
Member |
|
|
Hi,
I'm getting the following error in two of our databases. I'm also having trouble with these two datbases hanging sometimes, and thinking the rollback segment might be the problem...
Error:
ORA-1628: max # of extents 505 reached for rollback segment R01
Failure to extend rollback segment 2 because of 1628 condition
following are the segment configurations:
Name TableSpace Extents Size(M)
R01 RBS 43 5.039
R02 RBS 43 5.039
R03 RBS 43 5.039
R04 RBS 43 5.039
for all:
Initial size: 104 K bYTES
Next size: 104 Kbytes
Optimal size: 5120 K Bytes
Minimum number: 2
Maximum number: 505
I tried adding 1 more segment r05 and no change. I'm getting those errors in the alert log.
What is wrong?
Thanks
Paul
|
|
|
|