/SQL/Query to find table size in oracle 12c

Query to find table size in oracle 12c

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

1 vote295 views1 answer
Real world example of nosql
SQL
2 votes313 views1 answer
Sqlite3 show columns name
SQL
1 vote323 views2 answers
Sql insert timestamp
SQL
0 vote299 views1 answer
Sqlalchemy get ids
SQL
1 vote257 views1 answer
Restart identity postgresql
SQL
2 votes318 views4 answers
Mysql get all tables row count
SQL
0 vote295 views1 answer
Hive batch drop table
SQL
20 votes303 views4 answers
Sqlite create table if not exists
SQL
0 vote301 views1 answer
Sql select rows with different values in one column
SQL
1 vote257 views1 answer
Postgres division by zero
SQL