RE: Linux does not show the freed space by a drop tablespace

From: Ken Naim <kennaim_at_gmail.com>
Date: Fri, 7 Jul 2006 18:36:53 -0500
Message-ID: <016101c6a21e$3af19fb0$b4ae6a44@KenHome>

Yes, depending on the operating system it will not free up until the process that was accessing it release the handle. When I used to work on solaris 9 we used a command (which currently escapes me) that listed all the process id’s that had handles on each datafile, then we used that id and traced which session in oracle was accessing them and had the user relog so we didn’t need to bounce the database.

Ken Naim

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alfonso León
Sent: Friday, July 07, 2006 6:31 PM
To: oracle-l
Subject: Linux does not show the freed space by a drop tablespace

Have anybody has dropped a tablespace having oracle erasing the datafiles and when you check the free space in OS it was not freed although the datafiles are gone?

TIA
--

Alfonso Leon

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 07 2006 - 18:36:53 CDT