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 vote174 views1 answer
Oracle execute package dblink
SQL
1 vote162 views1 answer
Describe table in sql
SQL
0 vote149 views1 answer
Uncomment listen_address=localhost
SQL
2 votes189 views1 answer
Oracle insert or update
SQL
9 votes296 views2 answers
Current date in postgresql minus 1 day
SQL
-1 vote223 views5 answers
Left join
SQL
0 vote151 views1 answer
Cast as decimal postgresql
SQL
1 vote172 views1 answer
Difference between where and having clause
SQL
3 votes199 views1 answer
Query less than datetime sql
SQL
0 vote157 views1 answer
Sql remove first character from string
SQL