From oracle-l-bounce@freelists.org Tue Jul 19 08:49:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6JDnUd8011556 for ; Tue, 19 Jul 2005 08:49:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6JDnQIP011541 for ; Tue, 19 Jul 2005 08:49:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F8091D67E5; Tue, 19 Jul 2005 08:49:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19912-10; Tue, 19 Jul 2005 08:49:22 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B4D11D68B4; Tue, 19 Jul 2005 08:49:21 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:cc:references:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=KNoorrIr0G2cIovohow4D2rWElrfXBtH8ojG+m4NUaFoclF32hE1AE2gfzUNtOeXx+1WGzqGgrZ+nD9aPToh+qfqy9QsHh+jzFm15OkkB12U8emU5hLt3edzGh/e9PUEvwKy/wi82aYgJnDRrGXpOTCcPzp4/nbkQR8CCgdWG18= Message-ID: <039801c58c68$4ae58390$1a03310a@IBME1D11967173> From: "Radoulov, Dimitre" To: "'oracle-l'" Cc: "Lex de Haan" References: <42dbc7ef.330a0a38.7ed1.ffffe40aSMTPIN_ADDED@mx.gmail.com> Subject: Re: BIN$ objects (after media recovery) Date: Tue, 19 Jul 2005 15:46:38 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0395_01C58C79.0D104A30" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-archive-position: 22660 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-To: cichomitiko@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.2 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_0395_01C58C79.0D104A30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The BMC Patrol database health check include the create/drop test table = script .... every 3 min on our systems :) Immagine the impact on the = free space check after a few hours :) So we added the "purge" keword to the drop statement and restored the = _recyclebin settings:) Cheers, Dimitre Radoulov ------=_NextPart_000_0395_01C58C79.0D104A30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

The BMC Patrol database health = check include=20 the create/drop test table script .... every 3 min on our systems = :)=20 Immagine the impact on the free space check after a few hours = :)

So we added the "purge" keword to = the=20 drop statement and restored the _recyclebin=20 settings:)

Cheers,
Dimitre = Radoulov

------=_NextPart_000_0395_01C58C79.0D104A30-- -- http://www.freelists.org/webpage/oracle-l