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: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 02 Nov 2005 02:52:35 GMT
Message-ID: <Xns9701C0135A7ACSunnySD@68.6.19.6>


"001" <001_at_ms8.url.com.tw> wrote in news:dk98fs$bbs$1_at_jupiter.ttn.net:

> the real size means the size I used not I allocated.
> 
> 
> "HansF" <News.Hans_at_telus.net> 
> ???????:pan.2005.11.02.02.27.01.535284_at_telus.net...

>> On Wed, 02 Nov 2005 09:14:50 +0800, 001 amused us by writing:
>>
>>> Hi,
>>>
>>> The size showed on OEM is the size I allocated, isn't it?
>>> How can I calculate the real size of a table or a tablespace?
>>
>> What do you mean by 'the real size'?
>>
>> --
>> Hans Forbrich
>> Canada-wide Oracle training and consulting
>> mailto: Fuzzy.GreyBeard_at_gmail.com
>> *** Top posting guarantees I will not respond further ***
>>

>
>

subtract the amount reported by DBA_FREE_SPACE from the allocated size Received on Tue Nov 01 2005 - 20:52:35 CST

Original text of this message

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