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

0 vote88 views1 answer
Load utilities in sql server
SQL
0 vote101 views1 answer
Mysql range of dates overlap
SQL
12 votes109 views1 answer
Docker run mysql image
SQL
0 vote54 views1 answer
Sql injection mitigation
SQL
1 vote109 views1 answer
Python clean sql string
SQL
0 vote137 views1 answer
Postgresql alter table sequence
SQL
0 vote107 views1 answer
Mariadb hours between two dates
SQL
0 vote113 views1 answer
Sql query to return field name of a table
SQL
1 vote110 views3 answers
How to pass password to mysql command line
SQL
2 votes103 views1 answer
How to check if a row is null in sql
SQL