Re: Free space in segments

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.

HTH,
Pete's

Ralf Jonas <ralf.jonas_at_gmx.de> wrote in message news:<a28m2s$v4hnf$1_at_ID-6634.news.dfncis.de>...
> Does anyone know how to get the information how much space is left in a
> segment? I have a segment 50 GB in size. The extents are 20 MB each.
> This segment holds LOB-Data for our application. Of course I can
> calculate the amount of all the LOB-data with
>
> select sum(dbms_lob.getlength(data_field)) from xxx
>
> but this takes far too long for our needs. Seems I have to sum up the
> free space in each extent, but how?
>
> Thanks in advance
> Ralf Jonas
Received on Fri Jan 18 2002 - 07:45:58 CST