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

25 votes329 views5 answers
Uninstall mysql ubuntu
SQL
5 votes386 views2 answers
Add days in oracle sql
SQL
0 vote361 views1 answer
Oracle current timestamp insert statement
SQL
0 vote355 views1 answer
Default order by in mysql
SQL
0 vote309 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote327 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes312 views1 answer
Get first 3 letters name in sql
SQL
0 vote352 views1 answer
Set engine to innodb
SQL
0 vote335 views1 answer
Set root password mysql xampp
SQL
53 votes535 views6 answers
Sql server alter column
SQL