-
Max # extents reached for rollback segs
Hi,
I had encounter the below error. Can someone pls give your suggestion in order to get rid of the ora-1628 error? Tq
ORA-1628: max # extents 200 reached for rollback segment R03_HL
Failure to extend rollback segment 3 because of 1628 condition
FULL status of rollback segment 3 set.
-
SEGMENT_NAME MAX_EXTENTS PCT_INCREASE OWNER
--------------- ----------- ------------ ----------
SYSTEM 2147483645 0 SYS
R01_HL 200 0 SYS
R02_HL 200 0 SYS
R03_HL 200 0 SYS
R04_HL 250 0 SYS
R05_HL 200 0 SYS
R06_HL 200 0 SYS
R07_HL 200 0 SYS
R08_HL 200 0 SYS
R09_HL 250 0 SYS
R10_HL 300 0 SYS
-
increase the value of MAXEXTENTS
-
hi Slimdave,
is there any alternative beside increate the max_extents?
Tq
-
Hi samc,
1. Increase the NEXT parameter of the rollback segment :
ALTER ROLLBACK SEGMENT rollback_segment STORAGE (NEXT integer);
2. Increast the MAXEXTENTS storage parameter of the rollback segment:
ALTER ROLLBACK SEGMENT rollback_segment STORAGE ( MAXEXTENTS integer);
Regards,
Nir
-
hi,
what caused this error?
a very big transaction or import?
you can commit in between to minimise the
size of the transaction.
-Raja
-
Increase maxextents and specify OPTIMAL.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|