/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 vote334 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote365 views1 answer
Example database query
SQL
0 vote351 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote359 views1 answer
Raiserror with nowait
SQL
4 votes351 views1 answer
Restart for pg_hba.conf file
SQL
0 vote351 views1 answer
Sql bild in function
SQL
0 vote344 views1 answer
Oracle last character of string
SQL
6 votes377 views4 answers
Mysql group by date
SQL
12 votes379 views10 answers
Google
SQL
0 vote346 views1 answer
Add colum date in sql
SQL