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 vote142 views3 answers
My sql alter table
SQL
0 vote137 views2 answers
Tsql row number
SQL
17 votes147 views3 answers
How to change a collumn name in sql
SQL
5 votes128 views1 answer
Mysql add user with all privileges
SQL
0 vote142 views2 answers
How to generate a unique random number in mysql
SQL
0 vote139 views1 answer
Sql count null values in all columns
SQL
1 vote156 views2 answers
Create a unqie constraint mysql
SQL
0 vote161 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
2 votes95 views1 answer
Sql float to int
SQL
0 vote217 views1 answer
Site:av.ru "files"
SQL