Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I calculate the real size of a table or a tablespace?

Re: How can I calculate the real size of a table or a tablespace?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Nov 2005 05:04:53 -0800
Message-ID: <1130936693.717525.281630@f14g2000cwb.googlegroups.com> 





If the statistics are current the dba_tables.blocks X the
dba_tablespace.block_size will give the amount of space being used to
hold table rows plus the overhead in use.  In this case the overhead
would also include available space within the blocks but this is more
accurate measurement of the necessary space than just the number of
extents allocated.



HTH -- Mark D Powell --
Received on Wed Nov 02 2005 - 07:04:53 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US