SUMMARY:Solaris 2.6 disk space and Oracle 8.05

From: End User (UnixHelp_@excite.com)
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 [mailto:UnixHelp_@excite.com]
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!
http://www.home.com/xinbox/signup.html

S
U BEFORE POSTING please READ the FAQ located at
N ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/faq
. and the list POLICY statement located at
M ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/policy
A To submit questions/summaries to this list send your email message to:
N sun-managers@sunmanagers.ececs.uc.edu
A To unsubscribe from this list please send an email message to:
G majordomo@sunmanagers.ececs.uc.edu
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:
I http://www.latech.edu/sunman.html
S
T



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