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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 02 Nov 2005 03:57:00 GMT
Message-Id: <pan.2005.11.02.03.57.00.408261@sbcglobal.net> 





On Wed, 02 Nov 2005 10:27:32 +0800, 001 wrote:



> the real size means the size I used not I allocated.




As David has aptly pointed out, DBMS_SPACE.SPACE_USAGE is the best thing
to do. Why do you need that? What is the real problem? 


-- 
http://www.mgogala.com


Received on Tue Nov 01 2005 - 21:57:00 CST












Original text of this message













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