IF: ORA-1628 Reported Even For Small Transactions
Last updated on JUNE 29, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2016***
ORA-01628 errors i.e max # extents (32765) reached for rollback segment <SEGMENT_NAME> error reported even when the transactions are smaller
The maximum number of Undo extents possible in an Undo segment is 32k. By default the size of the Undo extents increase with the number, if there is enough free contiguous space in the Undo tablespace.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms