Server disk space was not freed after oracle deleted tablespace
Remember once, delete database physical files, disk space is not released.
Background Description:
Database business offline, delete business account, delete corresponding table space, free disk space
Operation Description:
1. drop user xxx cascade;
2. drop tablespace xxx including datafiles and contents
After deletion, the physical file is indeed deleted, but the df -h command does not free up space
lsof |grep deleted
View many processes occupying deleted oracle data files;
Get the corresponding spid, query in the database v$process and v$session,
The corresponding status is found to be "inactive". After killing the corresponding os process, disk space is released.
