Code: Select all
col owner format a15
col segment_name format a30
col segment_type format a15
col mb format 999,999,999
select owner
, segment_name
, segment_type
, mb
from (
select owner
, segment_name
, segment_type
, bytes / 1024 / 1024 "MB"
from dba_segments
order by bytes desc
)
where rownum < 11
/Code: Select all
OWNER SEGMENT_NAME SEGMENT_TYPE MB
--------------- ------------------------------ --------------- ------------
SYS IDL_UB1$ TABLE 168
SYS SOURCE$ TABLE 43
MDSYS SYS_LOB0000046428C00006$$ LOBSEGMENT 18
SYS IDL_UB2$ TABLE 17
SYS C_TOID_VERSION# CLUSTER 16
SH CUSTOMERS TABLE 12
SYS SYS_LOB0000046924C00004$$ LOBSEGMENT 9
SYS ARGUMENT$ TABLE 7
SYS C_OBJ# CLUSTER 7
SYS SYS_LOB0000046906C00004$$ LOBSEGMENT 7