i would agree with suhen 100% on this .. as it pretty much covers everything on this ..
Deepak --- Suhen Pather <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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).
