RE: df shows 100% on a empty filesystem-

From: Asif Momen <asif_oracle_at_yahoo.com>
Date: Wed, 16 Jan 2008 21:55:27 -0800 (PST)
Message-ID: <300069.70663.qm@web56611.mail.re3.yahoo.com>


Hi,

As Ken mentioned, I have also seen this happening on IBM-AIX (Oracle 10g R2) when I dropped a huge undo tablespace. We had to bounce the instance to reclaim the space.

Regards

Asif Momen
http://momendba.blogspot.com

Ken Naim <kennaim_at_gmail.com> wrote: v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} I have seen this happen frequently on various nix’s more commonly with dropped tablespace data files, as long as a process that is still running had accessed the file. I used lsof to find the process that was accessing the files, then ps to determine which app, then if it was an oracle process, either had the user exit their session or killed it. Occasionally it was smon/pmon and we had to wait or bounce the instance.    

  Ken           


  

  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber  Sent: Wednesday, January 16, 2008 6:31 PM  To: p4cldba_at_gmail.com
 Cc: oracle-l
 Subject: Re: df shows 100% on a empty filesystem-       

  Does anything besides oracle write to that file system? If not, try bouncing your instance if you can do that.     On Jan 16, 2008 4:39 PM, Prasad <p4cldba_at_gmail.com > wrote:   All,  

 The database is 10gR2 db running on solaris 8 .. There was archiver hung on archlogs01 filesystem . I moved all the archive logs to the backup filesystem . however df still shows archlogs01 100% filled.  

 du shows correctly  

 du -a /ofs/archlogs01

 4       /ofs/archlogs01/oracle/PLLS
 6       /ofs/archlogs01/oracle
 10      /ofs/archlogs01
 

 gdf -h shows incorrect  

 gdf -h | grep /ofs/archlogs01
 /dev/dsk/c2t0d11s0 2.9G 2.9G 2.0k 100% /ofs/archlogs01  

 fuser -c do not show me any active process running on /ofs/archlogs01  archive log stop also didnt help .  

 Any suggestions!  

 TIA
 Prasad          

 --
 Andrew W. Kerber  

 'If at first you dont succeed, dont take up skydiving.'              



Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 16 2008 - 23:55:27 CST

Original text of this message