Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: View to see free blocks in segments?

Re: View to see free blocks in segments?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 6 Dec 2001 06:30:47 +1100
Message-ID: <3c0e75e7$0$27196$afc38c87@news.optusnet.com.au>


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...

> Oracle 8.1.6
>
> Is there a view to see the free blocks in a segment?
>
> Brian
Received on Wed Dec 05 2001 - 13:30:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US