Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news1.optus.net.au!optus!spool01.syd.optusnet.com.au!spool.optusnet.com.au!210.49.20.118.MISMATCH!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <3c0e4ed4.1390685453@news.alt.net> Subject: Re: View to see free blocks in segments? Date: Thu, 6 Dec 2001 06:30:47 +1100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 26 Message-ID: <3c0e75e7$0$27196$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: 211.28.76.204 X-Trace: 1007580648 27196 211.28.76.204 Xref: easynews comp.databases.oracle.server:127253 X-Received-Date: Wed, 05 Dec 2001 12:35:02 MST (news.easynews.com) 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" wrote in message news:3c0e4ed4.1390685453@news.alt.net... > Oracle 8.1.6 > > Is there a view to see the free blocks in a segment? > > Brian