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 vote202 views3 answers
Drop unique key constraint in sql server
SQL
1 vote203 views5 answers
Postgresql difference between two dates in days
SQL
0 vote190 views1 answer
List column names of multiple tables psql
SQL
4 votes240 views2 answers
Insert current date in mysql
SQL
3 votes200 views2 answers
Oracle apex charging debug
SQL
5 votes188 views1 answer
Mysql change primary key
SQL
0 vote227 views1 answer
Mysql error codeigniter
SQL
0 vote204 views1 answer
T sql check active deadlock
SQL
0 vote197 views2 answers
Mysql get routine parameter list
SQL
6 votes199 views2 answers
Postgresql restore from dump
SQL