RE: df shows 100% on a empty filesystem-
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: asif_oracle@xxxxxxxxx, kennaim@xxxxxxxxx, andrew.kerber@xxxxxxxxx, p4cldba@xxxxxxxxx
- Date: Thu, 17 Jan 2008 15:15:12 +0800
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 <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:
