Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 22679 invoked from network); 7 Jul 2006 21:19:08 -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 21:19:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 662EA393D73; Fri, 7 Jul 2006 22:19:00 -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 14397-01; Fri, 7 Jul 2006 22:19:00 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D17C8393D0D; Fri, 7 Jul 2006 22:18:59 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Jul 2006 22:17:21 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 164E0393D3E for ; Fri, 7 Jul 2006 22:17:21 -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 14213-04 for ; Fri, 7 Jul 2006 22:17:21 -0400 (EDT) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.225]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DFAB3393D2B for ; Fri, 7 Jul 2006 22:17:20 -0400 (EDT) Received: by wr-out-0506.google.com with SMTP id 69so227397wri for ; Fri, 07 Jul 2006 19:17:27 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:x-mimeole:in-reply-to:thread-index; b=UHbfg9SCVaqa85LpkQ6FHyWRQu9QUzwFyk0w7/OD54tasOE/z8ssDG7agqdng947QAiQ6lMqNuqJ9Ju1oqrMHq0PXcbjRMv1KjNv4b1rdGfJAkuGaYGsjNIjaMHAElLsBpgAJaa/kQiNqtCo44FZP2UtjkGSbWlpO4m2Pq8dWCQ= Received: by 10.54.149.20 with SMTP id w20mr2270982wrd; Fri, 07 Jul 2006 19:17:27 -0700 (PDT) Received: from KenHome ( [68.106.174.180]) by mx.gmail.com with ESMTP id 39sm858838wrl.2006.07.07.19.17.26; Fri, 07 Jul 2006 19:17:27 -0700 (PDT) From: "Ken Naim" To: , "'oracle-l'" Subject: RE: Linux does not show the freed space by a drop tablespace Date: Fri, 7 Jul 2006 21:17:41 -0500 Message-ID: <018b01c6a234$b17ce7f0$b4ae6a44@KenHome> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 In-Reply-To: thread-index: AcaiJNmb/KWjLkWYQ3iDvlTGnc9vGwAD5iqQ X-archive-position: 36860 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 Just lsof and the full path of the file or if it was multiple file from the same tablespace lsof | grep tablespacename. Tablespace name was included included in all our file names. Second option does take a little while. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Greg Norris Sent: Friday, July 07, 2006 7:23 PM To: oracle-l Subject: Re: Linux does not show the freed space by a drop tablespace On 7/7/06, Alfonso León wrote: > > yep, I used lsof, but it doesn't show a process using the filesystem where > it was the datafile. What arguments did you pass to lsof? I've found "lsof +L1" to work rather well in your scenario, although it may need to be run by root rather than the oracle account. -- "I'm too sexy for my code." - Awk Sed Fred. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l