/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

1 vote227 views1 answer
Oracle stop job
SQL
1 vote229 views1 answer
Sql padd let with zeros
SQL
8 votes228 views1 answer
Oracle all_source package body
SQL
1 vote235 views1 answer
Mysql size int
SQL
0 vote246 views1 answer
Mysql update all record removing 2 hours from column
SQL
3 votes221 views1 answer
Sql set null
SQL
1 vote238 views1 answer
Postgresql define pk sequence next number
SQL
2 votes227 views1 answer
Get first 2 letter in sql
SQL
11 votes242 views2 answers
Mysql set safe mode off
SQL
0 vote241 views1 answer
Learnxinyminutes sql
SQL