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

Home -> Community -> Usenet -> c.d.o.misc -> 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