Need to run below query to check table size in MB.
SELECT owner,
segment_name,
segment_type,
tablespace_name,
bytes/1048576 MB,
initial_extent,
next_extent,
extents,
pct_increase
FROM
DBA_SEGMENTS
WHERE
OWNER = user AND
SEGMENT_TYPE = 'TABLE' order by MB desc;
SELECT owner,
segment_name,
segment_type,
tablespace_name,
bytes/1048576 MB,
initial_extent,
next_extent,
extents,
pct_increase
FROM
DBA_SEGMENTS
WHERE
OWNER = user AND
SEGMENT_TYPE = 'TABLE' order by MB desc;
No comments:
Post a Comment