SESSIONS STILL POINTING TO OLD DATAFILES AFTER DATAFILE MOVEMENT
(Doc ID 2640321.1)
Last updated on MARCH 12, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
lsof shows undotbs file as deleted but process still holds on. As a result available disk space reduces.
why is the process still holding the file when it is already deleted.
oracle_37 3794 oracle 259u REG 253,8 381314670592 15810561 /opt/oracle/base/oradata/<ora_instance>/datafile/o1_mf_undotbs1_gm4dcy5p_.dbf (deleted)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document