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

0 vote133 views1 answer
Sql make sure every user is unqiuew
SQL
15 votes311 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote146 views1 answer
Date on SQL
SQL
0 vote154 views1 answer
Gcloud sql list databases
SQL
0 vote155 views1 answer
Show table structure mysql console
SQL
3 votes143 views3 answers
Create table in microsoft sql server
SQL
4 votes202 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote148 views1 answer
How to join result table in mysql
SQL
1 vote139 views1 answer
Mysql select row with max value group by
SQL
-1 vote99 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL