RE: Question About Space Usage with LONG RAW Column
- From: "Mark Strickland" <mstrickland@xxxxxxxxxxxxx>
- To: <tanel.poder.003@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Oct 2004 14:47:34 -0700
Ok, thanks!
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der
Sent: Wednesday, October 20, 2004 2:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Question About Space Usage with LONG RAW Column
Hi!
> 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
If you have lots of empty blocks in your table, your rowid query doesn't
return those empty blocks.
You still have only one rowid per row, even though it might be chained
amongst several blocks - that could be another cause for discrepancy.
> 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!
How do you check the column position? dba_tab_columns shows the logical
position, check COL$.SEGCOL# column to see the real position of the =
column.
Tanel.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
