Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16780 invoked from network); 7 Jul 2006 18:37:30 -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 18:37:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DBFA3392E14; Fri, 7 Jul 2006 19:37:22 -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 22186-06; Fri, 7 Jul 2006 19:37:22 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A1E4393935; Fri, 7 Jul 2006 19:37:22 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Jul 2006 19:36:34 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A5DE392EE4 for ; Fri, 7 Jul 2006 19:36:34 -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 21965-06 for ; Fri, 7 Jul 2006 19:36:34 -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 E2EE2392A32 for ; Fri, 7 Jul 2006 19:36:33 -0400 (EDT) Received: by wr-out-0506.google.com with SMTP id 69so213220wri for ; Fri, 07 Jul 2006 16:36:40 -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:x-mailer:x-mimeole:in-reply-to:thread-index; b=uSs3O5cCH2pQKJjeb5RbNiOmSirJxXWoJEz0TYPzgWqpM2i5gLnh7xtZyOfPIJOINmV8yiM3UrkcaOs4+4OhdTz5DbbtRuWwbIjDU/mUUJ9V3fqn9xaJ//i+L0VRjyLXLSsw3INbs6Rm5nplcfY2MEWFkWlQUGo/49PpXxTxhzA= Received: by 10.54.140.17 with SMTP id n17mr2132649wrd; Fri, 07 Jul 2006 16:36:40 -0700 (PDT) Received: from KenHome ( [68.106.174.180]) by mx.gmail.com with ESMTP id 12sm4508257wrl.2006.07.07.16.36.39; Fri, 07 Jul 2006 16:36:40 -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 18:36:53 -0500 Message-ID: <016101c6a21e$3af19fb0$b4ae6a44@KenHome> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0162_01C6A1F4.521B97B0" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 In-Reply-To: <83a585ac0607071630h7fa99cb3tc153dd2dc251d925@mail.gmail.com> thread-index: AcaiHYvP6OAkYrJ1Q2iPnQHbWJiiRgAABOYw X-archive-position: 36853 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_0162_01C6A1F4.521B97B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Yes, depending on the operating system it will not free up until the = process that was accessing it release the handle. When I used to work on solaris = 9 we used a command (which currently escapes me) that listed all the = process id=92s that had handles on each datafile, then we used that id and = traced which session in oracle was accessing them and had the user relog so we didn=92t need to bounce the database. =20 Ken Naim =20 _____ =20 From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Alfonso Le=F3n Sent: Friday, July 07, 2006 6:31 PM To: oracle-l Subject: Linux does not show the freed space by a drop tablespace =20 Have anybody has dropped a tablespace having oracle erasing the = datafiles and when you check the free space in OS it was not freed although the datafiles are gone? =20 TIA --=20 Alfonso Leon=20 ------=_NextPart_000_0162_01C6A1F4.521B97B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Yes, depending on the operating = system it will not free up until the process that was accessing it release the = handle. 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, then we used that id and = traced which session in oracle was accessing them and had the user relog so we didn’t need to bounce the = database.

 

Ken = Naim

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Alfonso Le=F3n
Sent: Friday, July 07, = 2006 6:31 PM
To: oracle-l
Subject: Linux does not = show the freed space by a drop tablespace

 

Have anybody has dropped a tablespace having oracle erasing the datafiles and when you check the free space in OS it was not freed although the datafiles are gone?

 

TIA
--
Alfonso Leon

------=_NextPart_000_0162_01C6A1F4.521B97B0-- -- http://www.freelists.org/webpage/oracle-l