/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 vote407 views5 answers
Right join
SQL
0 vote294 views1 answer
Drush run sql select
SQL
0 vote299 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
4 votes298 views2 answers
Oracle last day of month
SQL
2 votes296 views2 answers
Run mysql command from bash
SQL
0 vote275 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote270 views1 answer
Myswql show full processlist
SQL
1 vote286 views1 answer
Oracle check table space
SQL
0 vote288 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote295 views1 answer
Sql use with to get value counts and percentages
SQL