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 vote152 views1 answer
How to select even id in sql
SQL
7 votes164 views1 answer
Mysql unsafe update
SQL
0 vote187 views1 answer
Sql server datetime
SQL
-1 vote95 views1 answer
How to create script to connect to oracle database and run query
SQL
1 vote180 views1 answer
Oracle select first row order by
SQL
0 vote139 views1 answer
MySql count occurences more than"
SQL
11 votes161 views1 answer
Oracle view source
SQL
0 vote171 views1 answer
Check command
SQL
0 vote153 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote150 views1 answer
Mysql local password denied
SQL