/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 vote353 views1 answer
Inner joint
SQL
0 vote349 views1 answer
Denormalise SQL command
SQL
53 votes577 views6 answers
Sql server alter column
SQL
1 vote356 views1 answer
How to update date add hours in postgresql
SQL
6 votes333 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote382 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote368 views1 answer
Sql not equal multiple columns
SQL
0 vote410 views1 answer
Check constraint is violated
SQL
0 vote358 views1 answer
First Step in installing SQL workbench
SQL
0 vote357 views1 answer
Sql developer sql worksheet not showing
SQL