Drop Tablespace Including Datafiles Does Not Recover Space on Solaris 10
Last updated on DECEMBER 25, 2016
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206.0 [Release 8.1.7 to 11.2]
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 25-Dec-2016***
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms