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 vote218 views1 answer
Postgresql define pk sequence next number
SQL
10 votes219 views4 answers
Else if mysql
SQL
-1 vote204 views1 answer
Ssms connect with connection string
SQL
0 vote186 views1 answer
Postgresql conectar
SQL
0 vote220 views1 answer
Mariadb set vertical output format
SQL
2 votes236 views2 answers
Null column to 0 in mysql
SQL
0 vote214 views1 answer
Mysql sum per week
SQL
2 votes224 views2 answers
Postgres timestamp to datetime
SQL
0 vote206 views1 answer
With_for_update sqlalchemy
SQL
3 votes223 views1 answer
Async await mysql nodejs
SQL