Discussions
Many UNEXPIRED UNDO extents
Hi,
our env. 12.2 RDBMS / GI and OL 7.4. Flashback enabled. UNDO_MANAGEMENT=AUTO, UNDO_RETENTION=900, MULTITENANT with local undo
I just wunder about many UNEXPIRED (20GB) UNDO extents.
I know, that UNEXPIRED extents are reused if the UNDO Tablespace is out of space and the datafile isn't extensible yet.
see:
From Oracle Doc:
For an undo tablespace with theAUTOEXTEND
option enabled, the database attempts to honor the minimum retention period specified byUNDO_RETENTION
. When space is low, instead of overwriting unexpired undo information, the tablespace auto-extends. If theMAXSIZE
1