Re: calculating space on tables

dmausner_at_brauntech.com (Dave Mausner) writes:

>In article <4n1cdn$s98_at_dfw-ixnews9.ix.netcom.com>,
> dcs1_at_ix.netcom.com(david sacks ) wrote:
>>Hi....
>>
>>Was wondering if anyone can help....am putting together some OPO forms
>>showing various statistics related to space management. For example,
>>tablespace allocation and fragmentation. I could use some help in
>>determining how to calculate the amount of space already used in
>>tables.
 

>analyze tables, then use the view dba_tables to display the amount of empty
>space within the allocated segment. from this you could calculate how much is
>used.

DBA_SEGMENTS is also handy

--
Oracle FAQ and archives maintainer
orafaq_at_bf.rmit.edu.au                 (private mail to dtb_at_bf.rmit.edu.au)
http://www.bf.rmit.edu.au/OracleFAQ   ftp://ftp.bf.rmit.edu.au/pub/Oracle/
http://www.bf.rmit.edu.au/Oracle      http://www.bf.rmit.edu.au/~orafaq
-- NOT TO BE ARCHIVED IN ANY MANNER ON MICROSOFT NETWORK --