Wednesday, July 25, 2018

How to check table size in oracle

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;

No comments:

Post a Comment