/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

6 votes245 views1 answer
Postgresql get year
SQL
0 vote244 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote211 views1 answer
Sql server on mac m1
SQL
0 vote206 views3 answers
Query string not ending with with vowels
SQL
0 vote182 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
5 votes239 views2 answers
Oracle show procedures
SQL
0 vote195 views1 answer
Sqlite referential integrity
SQL
7 votes195 views2 answers
MySQL IF without else
SQL
0 vote321 views1 answer
Placements hackerrank solution
SQL
0 vote231 views1 answer
How to check oracle index table
SQL