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_at_clearstream.com [SMTP:ddorr.cs_at_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_at_oracle-dba.com]
> > Reply To: ORACLE-L_at_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_at_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_at_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_at_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_at_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_at_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_at_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
Received on Thu Jun 01 2000 - 10:40:46 CDT