RBS PROBLEM

ORA-1628: max # extents 121 reached for rollback segment R10
Failure to extend rollback segment 16 because of 1628 condition
FULL status of rollback segment 16 set


ORA-1628: max # extents 121 reached for rollback segment R10
Failure to extend rollback segment 16 because of 1628 condition
ORA-1628: max # extents 121 reached for rollback segment R10
Failure to extend rollback segment 16 because of 1628 condition

Here I am having rollback segment problem.

So I resized the rollback segment tablespace.

again I having the same problem.

when I run particular transaction and particular user, that time only I am getting this error. not alwyas.

So what I want to do, please tell me.


My id is shankar_gk@hotmail.com,
kgshangs@yahoo.com


Bye,

G.shankar.

you need to increase the max_extents parameter --

ALTER ROLLBACK SEGMENT "R10" STORAGE ( MAXEXTENTS 500)


- Rajeev

you have 2 choices -

1) alter rollback segment R10 maxextents X
(where X = some number higher than 121, or 'unlimited'.

2) drop and recreate the rollback segment like this :
(obviously, you will have to change the commands a little)

alter rollback segment RBS1 offline
/

drop rollback segment RBS1
/

Create Public Rollback Segment RBS1
Tablespace RBS
Storage (
Initial 512K
Next 512K
Minextents 8
Maxextents 4096
Optimal 4194304
)
/

alter rollback segment RBS1 online
/