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 vote149 views1 answer
Copy data from cell to cell mysql
SQL
21 votes192 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote198 views1 answer
Oracle lower in where clause
SQL
25 votes210 views1 answer
How to update an attribute in MySQL
SQL
0 vote186 views1 answer
Uncomment listen_address=localhost
SQL
0 vote185 views1 answer
Différence entre deux dates sql oracle
SQL
14 votes202 views6 answers
Auto_increment mysql
SQL
4 votes171 views3 answers
Mysql varchar length
SQL
1 vote195 views1 answer
How to use db.execute
SQL
0 vote132 views1 answer
Ms sql print more than 1 variable
SQL