/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 vote144 views1 answer
Migrations.RunSQL
SQL
7 votes92 views1 answer
Safe mode mysql
SQL
0 vote112 views1 answer
Datetime postgres typeorm
SQL
0 vote125 views1 answer
Oracle synonym procedure dblink
SQL
1 vote125 views1 answer
Sql server get users
SQL
0 vote121 views1 answer
How to generate ids in sql
SQL
1 vote113 views1 answer
Sql dcl
SQL
3 votes118 views2 answers
Search text in all sql server stored procedure
SQL
3 votes144 views3 answers
Order by postgres
SQL
0 vote121 views2 answers
Temp Space
SQL