SUMMARY:Solaris 2.6 disk space and Oracle 8.05

From: End User (
Date: Wed Nov 08 2000 - 07:46:06 CST

I want to thank everyone for their help! Pretty much everyone had a correct
solution. Oracle still had the file open due to a remote sqlplus connection.
A `fuser -c /filesystem` showed the process that had the file open. Killed
the process and all is well

thanks again for the great help!

-----Original Message-----
From: End User []
Sent: Tuesday, November 07, 2000 1:45 PM
To: sunmgrs
Subject: Solaris 2.6 disk space and Oracle 8.05

Question regarding Oracle 8.05 on Solaris 2.6. My dba feels the OS is to
blame for the problem and I don't believe so. In a ufs filesystem, there is
an Oracle data file that occupies 90% of the filesystem. The dba has dropped
the tablespace within oracle and deleted the datafile, which was the *only*
file in this filesystem). However, a `df -k` still shows that 90% of the
filesystem is being used!! Does anyone have an idea why? I believe that
Oracle still has a reference of some sort to this removed file. I asked the
dba to shutdown the database to see if it frees the spae but unfortunalty we
can not do this right now. Has anyone experienced this situation before
and/or ave any remedies?

thanks in advance and I will summarize!

Say Bye to Slow Internet!

U BEFORE POSTING please READ the FAQ located at
. and the list POLICY statement located at
A To submit questions/summaries to this list send your email message to:
A To unsubscribe from this list please send an email message to:
E and in the BODY type:
R unsubscribe sun-managers
S Or
. unsubscribe sun-managers original@subscription.address
L To view an archive of this list please visit:

This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:14:21 CDT