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

5 votes117 views1 answer
Ora-00054 find lock
SQL
1 vote104 views1 answer
Oracle explain plan
SQL
0 vote119 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
9 votes138 views3 answers
Postgres make sql dump
SQL
0 vote73 views1 answer
Copy data from cell to cell mysql
SQL
1 vote109 views1 answer
Mysql select utc time in eastern time
SQL
0 vote115 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote116 views1 answer
Setval pgsql
SQL
0 vote128 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote131 views2 answers
Dumping sql table
SQL