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

2 votes175 views2 answers
Laravel query builder toSql
SQL
16 votes176 views2 answers
Add column if not exists mysql
SQL
2 votes152 views1 answer
Oracle sql drop column if exists
SQL
0 vote174 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote169 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote180 views1 answer
How to find database collation in postgres
SQL
4 votes169 views1 answer
Wildcard in sql
SQL
2 votes211 views1 answer
Username sql
SQL
9 votes197 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
1 vote168 views1 answer
Mysql select utc time in eastern time
SQL