Listen Software's How To: Calculating Tablespace and Table Byte Sizes

May 13, 2002

Tablespace Byte Sizes

select distinct 
       a.tablespace_name, 
sum(a.bytes) 
       as free_bytes,
sum(b.BYTES) 
       as Total_Bytes 
from dba_free_space a, 
     dba_data_files b 
Where a.tablespace_name = 
      b.tablespace_name 
group by a.tablespace_name

Table Byte Sizes

select segment_name,tablespace_name,bytes,blocks 
FROM DBA_SEGMENTS 
where segment_type='TABLE' AND TABLESPACE_NAME 
NOT IN('SYSTEM') order by bytes desc







The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers