Re: EMC Not Releasing Space

Hi,

This almost certainly has nothing to do with your symmetrix. The first two guesses I would make are:

1. oracle still has an open filehandle associated with the now-gone inode. The space will not be deallocated until thta filehandle is closed. You can use a tool like lsof to see if anyone still has on open fh associated with that object (for example, any session that had used that file before it was removed)
2. your file system has not updated it's metadata. Try syncing the file system a couple times and see if that fixes it (i.e. sync; sync; sync). Also, some filesystems (notably vxfs) have had bugs were the tools 'lied' about allocation information.

HTH, George

• http://www.pythian.com -- schlossnagle_at_pythian.com -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more.
  • Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 08, 2002 1:19 PM

> Hi,
>
> Just curious if anyone has any experience with an EMC
> Symmetrix not releasing the space for a deleted
> datafile. If so, is there a solution or work-around?
>
> Yesterday, we took a tablespace offline, dropped it
> and then deleted the associated datafile. The file was
> 1G in size and today the space has still not been
> released as indicated by 'df -k'. According to another
> DBA here, they have seen this in the past and said
> bouncing the DB remedied the problem.
>
> It sounds like the inodes are still in use by Oracle
> but I can't imagine why. I've worked with Symmetrix
> systems before and have never experienced this
> behavior. We are running 8.1.7.2 (64bit) on Solaris
> 2.8. Any suggestions?
>
> As always, your feedback is appreciated.
>
> -w
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Walter K
> INET: alden14004_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: schlossnagle_at_pythian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).