Oracle table size

SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
FROM dba_extents e
WHERE
  e.OWNER = 'SCHEME_NAME' AND
  e.TABLESPACE_NAME = 'TBS_NAME' AND
  e.SEGMENT_NAME IN ('TABLE_NAME')
GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;

Similar codes

0 vote320 views1 answer
Postpresql relation not found
SQL
0 vote332 views1 answer
Postgres where
SQL
17 votes329 views4 answers
Set mysql Password
SQL
0 vote400 views1 answer
Osm2pgsql mac
SQL
1 vote337 views1 answer
Events mysql
SQL
-1 vote372 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote335 views1 answer
Commit transaction sql
SQL
22 votes363 views4 answers
Mysql date_format
SQL
3 votes340 views4 answers
Stop MySQL
SQL
9 votes332 views2 answers
Sql limit order by
SQL