Oracle table size

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 vote306 views1 answer
Primary key reset in SQL database
SQL
0 vote167 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
3 votes173 views2 answers
Postgres inner join vs join
SQL
0 vote188 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
2 votes174 views1 answer
Mysql how to store lat,lng
SQL
11 votes216 views3 answers
Change column name sql server management studio
SQL
0 vote191 views2 answers
List all constraints in postgres
SQL
1 vote175 views1 answer
Sql drop with dependencies
SQL
0 vote171 views1 answer
Json not contains mysql
SQL
3 votes202 views5 answers
No module named 'MySQLdb'
SQL