Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Free space in segments
Hi Pete,
> One way would be to analyze the object, estimate statistics would
> suffice, but, if you need the most accurate you will need to do a
> compute statistics. Given that htis is a 50 gb object, you would
> probably want to estimate. After that is finished, check the table
> out via select * from dba_tables where table_name = 'YOUR_TABLE_NAME'.
> Then check out the number of free_blocks and avg free space per
> block(for used blocks) and the number of blocks used. You should get
> the idea now, I hope.
this doesn't work for me, because most of the data is stored in a BLOB. Of course I testet "compute statistics" and I analyzed the data from user_tables. But when I changed the data in the BLOB-field in length, I couldn't find any diffrence in user_tables.
This surely works fine with normal table data, but not with BLOB-fields, because this data is not stored in the table segment itself, but in external LOB-segments.
Ralf Received on Mon Jan 21 2002 - 02:26:08 CST