/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

0 vote293 views1 answer
Sql gather statistics to increase performance
SQL
5 votes265 views1 answer
Oracle scan source ddl
SQL
0 vote254 views1 answer
Sqldf change user
SQL
2 votes274 views1 answer
Sql server check for value in multiple columns
SQL
16 votes281 views1 answer
Sql comment'
SQL
0 vote278 views1 answer
Drush run sql select
SQL
-1 vote284 views5 answers
Operator in sql
SQL
0 vote265 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote268 views1 answer
How to use lower case in mysql
SQL
4 votes277 views2 answers
Mysql delete user if exists
SQL