/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 vote256 views1 answer
Check current sequence value postgres
SQL
1 vote238 views1 answer
Last 6 months postgresql
SQL
0 vote228 views1 answer
Porcentaje sql
SQL
0 vote242 views1 answer
Tsql pad left
SQL
1 vote239 views1 answer
Oracle activate job
SQL
0 vote237 views2 answers
Postgres default user
SQL
-1 vote241 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote245 views1 answer
Postgresql delete cascade
SQL
0 vote254 views1 answer
Oracle sql copy table without data
SQL
0 vote231 views3 answers
Mysql delete if not in another table
SQL