query to find table size in oracle 12c

Solutions on MaxInterview for query to find table size in oracle 12c by the best coders in the world

showing results for - "query to find table size in oracle 12c"
Bria
22 Apr 2016
1SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
2FROM dba_extents e
3WHERE
4  e.OWNER = 'SCHEME_NAME' AND
5  e.TABLESPACE_NAME = 'TBS_NAME' AND
6  e.SEGMENT_NAME IN ('TABLE_NAME')
7GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
8ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;