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

7 votes265 views2 answers
Oracle foreign key reference table
SQL
1 vote195 views1 answer
How to set up a trigger in sql
SQL
1 vote207 views1 answer
Hangfire clear all jobs
SQL
0 vote195 views2 answers
Sql 2 way of select unique
SQL
1 vote205 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote225 views1 answer
Get create sql of hibernqte entity
SQL
2 votes174 views1 answer
Postgresql left join distinct on
SQL
0 vote182 views1 answer
Events not working db
SQL
0 vote182 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote150 views1 answer
Mysql insert with foreign key
SQL