RE: Unix Command

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Thu, 20 Apr 2006 22:52:03 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E3601B382AE@CWYMSX04.Corp.Acxiom.net>

I find that frequently, when I drop a tablespace, the datafiles at the OS level are still held opened by dbsnmp user - intelligent agent (under 9i, at least). I believe its related to one of the monitoring jobs I have running out of OEM, as after about 15 minutes these processes release their hold. A restart of the agent also releases their hold.

I'm pretty paranoid about removing files, so after dropping a tablespace, I run a UNIX script which compares files found within Oracle OFA directories for the given database and those found within the database. Any at the UNIX level and not in the database are potentials for removal. I feel alot safer having this list come back to me when it matches that of the datafiles for the tablespace I just dropped. I then run an "fuser" against each datafile before I remove it. Once all datafiles come back as having no associated PIDs, I remove them.

HTH Dave

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com>

"When I come home from work and see those little noses pressed against the windowpane, then I know I am a success" - Paul Faulkner

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Steve Perry
> Sent: Thursday, April 20, 2006 9:44 PM
> To: Oracle-L Freelists
> Subject: Re: Unix Command
>
> Somebody else mentioned the same thing with 9i, AIX on EMC Symmetrix.
> She dropped a tablespace and datafiles. It took 12 hours or more
> before they could reuse it.
>
> i'd love to know if this is an oracle issue or OS.
> Right now it's just finger pointing.
>
> Steve
>
>
> On Apr 20, 2006, at 02:36 PM, Baumgartel, Paul wrote:
>
> > Just yesterday I did a "drop tablespace ... including contents and
> > datafiles" (9.2.0.6 on Solaris). The filesystem space freed up
> > later, but not immediately after the drop.
> >
> > Paul Baumgartel
> > paul.baumgartel_at_credit-suisse.com
> > 212.538.1143
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante,
> > Thomas F
> > (LABOR)
> > Sent: Thursday, April 20, 2006 2:43 PM
> > To: Oracle-L Freelists
> > Subject: Unix Command
> >
> >
> > All,
> >
> > There is a unix command to show who has what files open on a mount
> > point
> > - anybody remember what it is?
> >
> > We dropped a tablespace along with the data files, but the space
> > was not
> > released. I'm thinking that somehow Oracle did not release the
space
> > yet. Anybody remember something like this?
> >
> > This is on Sun Solaris/9.2.0.5.
> >
> > Thanks
> >
> > Tom
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >

> > ========
> > Please access the attached hyperlink for an important electronic
> > communications disclaimer:
> >
> > http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> >

> > ========
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 20 2006 - 22:52:03 CDT