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

4 votes163 views5 answers
Get last query in codeigniter 4
SQL
1 vote184 views1 answer
Postgres set sequence value to max id
SQL
0 vote137 views1 answer
Php mysqli install
SQL
11 votes128 views1 answer
Mysql order by two columns priority
SQL
0 vote138 views1 answer
Multiple tricky query in sql server
SQL
0 vote125 views1 answer
How to connect postgresql database with java
SQL
0 vote130 views1 answer
Select from column mysql
SQL
0 vote167 views1 answer
SQL Server Enterprise
SQL
0 vote138 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote159 views1 answer
Backup mysql schema only
SQL