I believe that the UNUSED_BLOCKS return value refers to blocks that have never been used, which would be blocks above the HWM.
Jared Suhen Pather <Suhen.Pather@strandba To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> gs.com.au> cc: Sent by: Subject: RE: unused blocks BELOW HWM [EMAIL PROTECTED] 12/17/01 04:45 PM Please respond to ORACLE-L Gene, I do not think you can do this with dbms_space. The way I normally try to locate if the HWM of a table is too high is: - analyze each table - use avg_row_len and num_rows columns from user_tables to calculate the Used Space (you can also put pctfree and pctused into this equation). - compare the Used Space to the HWM (allocated space - empty blocks -1) - If the Used Space and HWM are considerably different then you should recreate the table to save *wasted space*. I am sure this is not the most efficient way of doing this but it works for me. Regards Suhen are u saying try it or are you saying that you can find this info using dbms_space;) Thx Deepak --- "Sairlao, Chark" <[EMAIL PROTECTED]> wrote: > try dbms_space > > Thanks And Regards > Chark Sairlao > > > -----Original Message----- > Sent: Tuesday, 18 December 2001 9:40 > To: Multiple recipients of list ORACLE-L > > > no there is not .. unless someone corrects me that > is > ;) > > Deepak > > > --- Gene Gurevich <[EMAIL PROTECTED]> wrote: > > Hi all: > > > > Is there a way for me to see how many blocks under > > the HWM are unused? > > > > thanks > > > > Gene > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).