Re: df shows 100% on a empty filesystem-
Date: Thu, 17 Jan 2008 01:55:08 -0800
there is a cronjob running which moves( mv) the archivelogs from /ofs/archlogs01 to another fielsystem. I suspect that as you mentioned it might be struck while moving partially completed archivelog files. so is there a way to validate the archivelog file size (bytes). I tried with v$archived_log ( blocks*block_size) . but somehow it do not seems to .
On Jan 16, 2008 11:15 PM, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> When datafiles are not released after dropping a tablespace then again
> lsof is useful for identifying which process still holds the files open.
> I've experienced a similar case in Oracle 9.2 on Solaris, it turned out
> that the idle job queue processes still had the files open even after
> tablespace was dropped. As I did not want to bounce the instance just
> because of that, I set job_queue_processes = 0, waited until the processes
> died (and the files were released) and set job_queue_processes back to
> original again.
> Tanel Poder
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Asif Momen
> *Sent:* Thursday, January 17, 2008 13:55
> *To:* kennaim_at_gmail.com; andrew.kerber_at_gmail.com; p4cldba_at_gmail.com
> *Cc:* 'oracle-l'
> *Subject:* RE: df shows 100% on a empty filesystem-
> 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.
> Asif Momen