Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View to see free blocks in segments?
Analyze table blah compute statistics;
Then...
select empty_blocks from dba_tables where table_name='BLAH';
Empty blocks are blocks which have been allocated to the table, but which have never been touched by data. They are thus above the High Water Mark, and can consequently be thought of as 'free'.
Regards
HJR
-- Resources for Oracle: http://www.hjrdba.com =============================== "Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in message news:3c0e4ed4.1390685453_at_news.alt.net...Received on Wed Dec 05 2001 - 13:30:47 CST
> Oracle 8.1.6
>
> Is there a view to see the free blocks in a segment?
>
> Brian