Message-Id: <10515.107399@fatcity.com> From: "Wasserman, Sara" Date: Thu, 1 Jun 2000 08:40:46 -0700 Subject: RE: Finding the actual size of a table I find that NUM_ROWS * AVG_ROW_LEN is reasonably accurate, but BLOCKS is the number of blocks EVER used, not the number currently in use. HTH, Sara Wasserman > -----Original Message----- > From: ddorr.cs@clearstream.com [SMTP:ddorr.cs@clearstream.com] > Sent: Wednesday, May 31, 2000 5:05 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Finding the actual size of a table > > I've always thought you could get valuable information from DBA_TABLES, > assuming tables have been ANALYZEd. > > NUM_ROWS * AVG_ROW_LEN gives the space used by a table, > BLOCKS gives the number of blocks used, > > Am I missing something ??? > > > ---------- > > From: Joseph S. Testa[SMTP:teci@oracle-dba.com] > > Reply To: ORACLE-L@fatcity.com > > Sent: Tuesday, May 30, 2000 23:10 > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Finding the actual size of a table > > > > it does not exist in a view, look at $ORACLE_HOME/rdbms/admin > > > > look for dbmsutil.sql, in there is dbms_space package, thats what you > want > > to > > use. > > > > joe > > > > > > Steven Monaghan wrote: > > > > > Which data dictionary view can I use to determine the actual size of a > > > table, not just the extents allocated to it? > > > > > > I will be moving a database to a new machine in a few weeks, and I > want > > to > > > start planning out the initial extent sizes for my tables. I don't > want > > to > > > just use exp/imp with compress=Y because I want to manually size some > of > > my > > > smaller reference tables with a large enough initial extent so they > > don't > > > need to grow to reduce potential fragmentation. > > > > > > I also have TOAD but couldn't find the answer there either. > > > > > > TIA, > > > Steve Monaghan > > > WorldCom > > > > > > -- > > > Author: Steven Monaghan > > > INET: Steve.Monaghan@wcom.com > > > > > > 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: ListGuru@fatcity.com (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). > > > > -- > > Author: Joseph S. Testa > > INET: teci@oracle-dba.com > > > > 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: ListGuru@fatcity.com (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). > > > -- > Author: > INET: ddorr.cs@clearstream.com > > 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: ListGuru@fatcity.com (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