Tuesday, December 05, 2006

RDBMS:Oracle:Know physical size of DB objects

This is the query through which we can know the physical space occupied by the DB objects in Oracle for a schema. This returns the size in MB.

select segment_name,sum(bytes)/1024/1024 "SIZE in MB"
from dba_extents
where owner = 'OWNER_NAME'
group by segment_name

No comments: