In the view DBA_UNDO_EXTENTS,what does the values "EXPIRED & UNEXPIRED" of STATUS column mean?
Active - There is an active transaction using this UNDO extent.
Unexpired - There is no active transaction, but the extent is not available for reuse.
Expired - The extent can be reused.
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCA PL/SQL Developer
Oracle ACE Director
My website: www.oracle-base.com
My blog: www.oracle-base.com/blog