My Oracle Support Banner

Drop Tablespace Including Datafiles Does Not Recover Space on Solaris 10 (Doc ID 356708.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 11.2]
Oracle Solaris on SPARC (64-bit)


Space is not released to the OS when a tablespace is dropped from the database.
After the instance is closed, the space taken by the files belonging to the tablespace is immediately released back to
the OS.

This would be the expected behaviour according to:

<NOTE:112218.1> - Space not Released back to O/S when Datafiles have been Dropped

when there are foreground processes hold the file(s) open. But in this situation there are only 2 background processes holding the file open: dbwr (expected) and smon (not expected). smon process is the one that causes the situation.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.