/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 vote129 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote125 views4 answers
First max salary in sql
SQL
5 votes125 views2 answers
Mysqldump password
SQL
0 vote124 views1 answer
Console output pl sql
SQL
0 vote140 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote205 views1 answer
Sql if clause within where clause
SQL
-1 vote129 views1 answer
Condition in orderby mysql
SQL
0 vote144 views1 answer
Copy row from db to db mysql
SQL
0 vote125 views1 answer
Sql grant select only
SQL
-1 vote123 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL