Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question About Space Usage with LONG RAW Column
I think #1 is the cause. Rows are archived out of the table
periodically, so there have been a lot of deleted rows. There aren't
that many chained rows. Thx!
Mark
-----Original Message-----
From: Christian Antognini [mailto:Christian.Antognini_at_trivadis.com]=20
Sent: Wednesday, October 20, 2004 2:27 PM
To: Mark Strickland
Cc: oracle-l_at_freelists.org
Subject: RE: Question About Space Usage with LONG RAW Column
Hi Mark
In my opinion two possibilities:
Chris
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark
>Strickland
>Sent: 20 October 2004 22:51
>To: oracle-l_at_freelists.org
>Subject: Question About Space Usage with LONG RAW Column
>
>I did a count of the number of blocks of a Kana table (kc_rawtext) with
>this query: =3D20
>
> select count (distinct substr(rowid,7,9)) from kc_rawtext. =3D20
>
>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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 20 2004 - 16:27:50 CDT
![]() |
![]() |