From oracle-l-bounce@freelists.org Wed Oct 20 15:46:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9KKk9D25507 for ; Wed, 20 Oct 2004 15:46:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9KKk8I25502 for ; Wed, 20 Oct 2004 15:46:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C256172E1F7; Wed, 20 Oct 2004 15:52:12 -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 23163-99; Wed, 20 Oct 2004 15:52:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2C74172D2E8; Wed, 20 Oct 2004 15:52:12 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: Question About Space Usage with LONG RAW Column Date: Wed, 20 Oct 2004 13:50:31 -0700 Message-ID: <63A70CA32CEF354892F78EADB13D32970339F00A@seaems005c> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Question About Space Usage with LONG RAW Column Thread-Index: AcStg217DUWFKywxQY+2n7xof6ryawAB11+gALxgxqAAnxiEQAD7RIWw From: "Mark Strickland" To: X-OriginalArrivalTime: 20 Oct 2004 20:50:32.0114 (UTC) FILETIME=[709AC120:01C4B6E6] X-archive-position: 11330 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mstrickland@drugstore.com Precedence: normal Reply-To: mstrickland@drugstore.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I did a count of the number of blocks of a Kana table (kc_rawtext) with this query: =20 select count (distinct substr(rowid,7,9)) from kc_rawtext. =20 The result is 2,198,800 blocks. However, user_tables.blocks shows 4,113,400 blocks. I'm trying to figure out the discrepancy. The table has a LONG RAW column and it appears that the column is not the last column in the table (column_id for the LONG RAW column is #3 out of five columns). The table grows quickly. Can someone help me understand where the space is going? Thx! Mark Strickland -- http://www.freelists.org/webpage/oracle-l