/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

3 votes174 views2 answers
Sql paging query
SQL
0 vote183 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote192 views1 answer
Sql query to find duplicate email address
SQL
0 vote189 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote182 views1 answer
Mysql uuid
SQL
9 votes193 views4 answers
Mysql set id auto increment
SQL
0 vote185 views1 answer
Get the next column of a table in mysql
SQL
1 vote178 views1 answer
Oracle sql listagg
SQL
1 vote187 views1 answer
Mysql select from outside
SQL
1 vote189 views1 answer
Mysql column start with string
SQL