Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE : Filesystem not freeing up space

RE : Filesystem not freeing up space

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Fri, 27 Oct 2000 10:55:58 +0200
Message-Id: <10662.120408@fatcity.com>


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
------------------------------------------------------------------

>
> 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
Received on Fri Oct 27 2000 - 03:55:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US