Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE : Filesystem not freeing up space
Lee,
The only thing which springs to my mind is your database being in ARCHIVELOG mode - with everything archived to the same filesystem. Any reorg usually generates a lot of redo.
-- Regards, Stephane Faroult email: sfaroult_at_oriolecorp.com Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools & Free Scripts ------------------------------------------------------------------ http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs ------------------------------------------------------------------Received on Fri Oct 27 2000 - 03:55:58 CDT
>
> All,
>
> Oracle 8.0.5
> Tru64 4.0f Patch Kit 3
>
> Last night, I was rebuilding a tablespace to free up about 12Gb of unused
> space. All the initial stuff went fine.
>
> Drop indexes
> Drop tablespace
> Remove OS files
> Rebuild tablespace
> Create indexes
>
> All of this went perfectly yet when I looked at the df output, as opposed to
> having 12Gb free I now have less space than I started with. I know inreality
> that this is not the case and that for some reason the OS is hanging onto
> something but I don't know what.
>
> I have done fuser and lsof commands, bounced the database but still no joy.
>
> I have seen this once before on an Oracle 7.3.4 database on Sequent Dynix
> and our only solution in the end was to bounce the server. This isn't really
> an option here.
>
> Any ideas
>
> TIA
>
>
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007