OraMatt: YABAOracle

/* Get the Owner, Object Name, Size, Tablespace & Filename for Oracle objects */

set linesize 120
col "Object Name" format a30

select 
	distinct 
    o.owner "Owner",
    o.object_name "Object Name", 
    (s.bytes/1024/1024)"MB",
    f.tablespace_name "Tablespace",
    f.file_name "File Name"
from 
	dba_data_files f, 
	dba_segments s, 
	dba_objects o 
where 
	f.tablespace_name = s.tablespace_name and s.segment_name = o.object_name and o.owner not in ('SYSTEM','SYSAUX','SYS','SYSMAN')
order by "MB" desc;