Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 17999 invoked from network); 7 Jul 2006 19:09:06 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 7 Jul 2006 19:08:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54D8C39406A; Fri, 7 Jul 2006 20:08:47 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27659-01; Fri, 7 Jul 2006 20:08:47 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BE57F393C1C; Fri, 7 Jul 2006 20:08:46 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Jul 2006 20:07:59 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E76A4393795 for ; Fri, 7 Jul 2006 20:07:58 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27362-09 for ; Fri, 7 Jul 2006 20:07:58 -0400 (EDT) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.239]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 71DFC392E7F for ; Fri, 7 Jul 2006 20:07:58 -0400 (EDT) Received: by wr-out-0506.google.com with SMTP id 69so216216wri for ; Fri, 07 Jul 2006 17:08:05 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:cc:subject:date:message-id:mime-version:content-type:x-mailer:x-mimeole:in-reply-to:thread-index; b=sk9HNmfAwavC+Py7cxY+e/2gZj9hOUdncLuAXmweo69/SP4xkdHVvIgZCfPqWLkNgVj3U46Z9e3Af8R/VIvvTrcmO99QrUKXLpV4+v8blrK01Hc5nnw3S/GmfAPaULtoqC4MrgTyAeWiZqe4voOUwZ+d6eDpgbFT3en7j7dKkec= Received: by 10.54.140.13 with SMTP id n13mr2155748wrd; Fri, 07 Jul 2006 17:08:05 -0700 (PDT) Received: from KenHome ( [68.106.174.180]) by mx.gmail.com with ESMTP id 26sm571109wrl.2006.07.07.17.08.04; Fri, 07 Jul 2006 17:08:04 -0700 (PDT) From: "Ken Naim" To: =?iso-8859-1?Q?'Alfonso_Le=F3n'?= , "'Allen, Brandon'" Cc: "'oracle-l'" Subject: RE: Linux does not show the freed space by a drop tablespace Date: Fri, 7 Jul 2006 19:08:18 -0500 Message-ID: <017a01c6a222$9e65fe70$b4ae6a44@KenHome> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_017B_01C6A1F8.B58FF670" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 In-Reply-To: <83a585ac0607071657s7897874x4df29ae958a5ad68@mail.gmail.com> thread-index: AcaiISVMhlJa7CxzRDaJmQC73b9SeAAAW5gg X-archive-position: 36857 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: kennaim@gmail.com Precedence: normal Reply-to: kennaim@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_NextPart_000_017B_01C6A1F8.B58FF670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable You might have to do it, prior to removing the file. =20 _____ =20 From: Alfonso Le=F3n [mailto:aleon68@gmail.com]=20 Sent: Friday, July 07, 2006 6:58 PM To: Allen, Brandon Cc: kennaim@gmail.com; oracle-l Subject: Re: Linux does not show the freed space by a drop tablespace =20 yep, I used lsof, but it doesn't show a process using the filesystem = where it was the datafile. =20 On 7/7/06, Allen, Brandon wrote:=20 Maybe fuser or lsof? =20 _____ =20 From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org] = On Behalf Of Ken Naim Sent: Friday, July 07, 2006 4:37 PM To: aleon68@gmail.com; 'oracle-l' Subject: RE: Linux does not show the freed space by a drop tablespace =20 . . . When I used to work on solaris 9 we used a command (which = currently escapes me) that listed all the process id's that had handles on each datafile . . . =20 Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do = not consent to Internet email for messages of this kind. Opinions, = conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor = endorsed by it.=20 --=20 Alfonso Leon=20 ------=_NextPart_000_017B_01C6A1F8.B58FF670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

You might have to do it, prior to = removing the file.

 

From: = Alfonso Le=F3n [mailto:aleon68@gmail.com]
Sent: Friday, July 07, = 2006 6:58 PM
To: Allen, Brandon
Cc: kennaim@gmail.com; = oracle-l
Subject: Re: Linux does = not show the freed space by a drop tablespace

 

yep, I used lsof, but it doesn't show a process using the = filesystem where it was the datafile.

 

On 7/7/06, Allen, Brandon <Brandon.Allen@oneneck.com&g= t; wrote:

Maybe fuser or = lsof?

 

From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org] On Behalf Of Ken Naim
Sent: Friday, July 07, = 2006 4:37 PM
To: aleon68@gmail.com; 'oracle-l'
Subject: RE: Linux does = not show the freed space by a drop tablespace

 

 . . .  When I = used to work on solaris 9 we used a command (which currently escapes me) that = listed all the process id's that had handles on each = datafile  . . .  =

Privileged/Confidential Information may = be contained in this message or attachments hereto. Please advise = immediately if you or your employer do not consent to Internet email for messages of = this kind. Opinions, conclusions and other information in this message that = do not relate to the official business of this company shall be understood as = neither given nor endorsed by it.




--
Alfonso Leon

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