Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h3LIDFx12978 for ; Mon, 21 Apr 2003 13:13:16 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h3LIDFA12969 for ; Mon, 21 Apr 2003 13:13:15 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA66779; Mon, 21 Apr 2003 08:45:46 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00585DEB; Mon, 21 Apr 2003 08:27:12 -0800 Message-ID: Date: Mon, 21 Apr 2003 08:27:12 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Don Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Don Subject: Free up usable block space with a query? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Content-Transfer-Encoding: 7bit Another Oracle DBA told me recently that by running a query that forces a full table scan, he can obtain additional blocks usable for inserts. The thought was that the full-table scan somehow "forces" a block to become usable for inserts if the actual amount of block space used is some value that is "just above" the PCTUSED value of the object. He did not discuss how the value of "just above" the PCTUSED was determined. Can anybody shed any technical insights on this topic? Is this an urban legend? Thx in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don INET: dondealy@teleport.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).