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

-3 votes95 views1 answer
Remove spaces sql 2008
SQL
2 votes92 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote97 views2 answers
Mysql disable foreign key checks
SQL
0 vote104 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote97 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote162 views1 answer
How to find the most occuring in SQL
SQL
0 vote116 views1 answer
Sql commands in android
SQL
0 vote104 views1 answer
Sql select non unique
SQL
-1 vote97 views1 answer
How to use update trigger in sql
SQL
0 vote137 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL