/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 vote97 views1 answer
How to open mysql in docker
SQL
5 votes110 views2 answers
Ranking functions in sql
SQL
-1 vote89 views1 answer
Plsql while
SQL
1 vote119 views2 answers
Full join
SQL
1 vote113 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote109 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote96 views1 answer
Hw to delete a procedure in pl sql
SQL
3 votes88 views1 answer
Sql timestamp to date
SQL
1 vote97 views1 answer
Media sql
SQL
0 vote60 views1 answer
Mysql insert with foreign key
SQL