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 vote198 views1 answer
Oracle stop job
SQL
0 vote197 views2 answers
Sql query for getting details by id
SQL
0 vote192 views1 answer
Null column as zero in mysql
SQL
0 vote217 views1 answer
Search column name sql
SQL
0 vote182 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote269 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote197 views1 answer
Update from table tsql
SQL
3 votes197 views1 answer
Sql print all names that start with a given letter
SQL
0 vote188 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote228 views1 answer
How to open mysql in docker
SQL