Re: df shows 100% on a empty filesystem-

Hi Tanel,

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 .

Thanks
-Prasad

On Jan 16, 2008 11:15 PM, Tanel Poder <tanel.poder.003@xxxxxxx> 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.
>
> --
> Regards,
> Tanel Poder
> http://blog.tanelpoder.com
>
>
>  ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Asif Momen
> *Sent:* Thursday, January 17, 2008 13:55
> *To:* kennaim@xxxxxxxxx; andrew.kerber@xxxxxxxxx; p4cldba@xxxxxxxxx
> *Cc:* 'oracle-l'
> *Subject:* RE: df shows 100% on a empty filesystem-
>
> 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
>
>

Other related posts: