OraFAQ Forum: Server Administration » Help! Failure to extend rollback segment 2 because of 1628 condition

Home » RDBMS Server » Server Administration » Help! Failure to extend rollback segment 2 because of 1628 condition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Help! Failure to extend rollback segment 2 because of 1628 condition [message #51982 is a reply to message #51981]

Mon, 24 June 2002 15:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try
ALTER ROLLBACK SEGMENT rollback_segment STORAGE ( MAXEXTENTS UNLIMITED);
if that doesnt help you, then
drop and recreate the RBS with higher( double?)
the initial and next or
create a large RBS and assign that to this particular transaction.
apply the commits frequently.

Report message to a moderator

Previous Topic:	Rollback Segments
Next Topic:	ora-27500

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:29:45 CDT 2024