-
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
/