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

11 votes126 views5 answers
Sql server reset identity
SQL
0 vote109 views1 answer
T-SQL Never ending DELETE
SQL
0 vote112 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote119 views1 answer
Left join in codeigniter query builder
SQL
0 vote126 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote110 views1 answer
Postgresql update to unique
SQL
11 votes177 views2 answers
Sql between date range
SQL
0 vote113 views1 answer
If null don't update
SQL
0 vote116 views1 answer
C# mysql update statement set value to null
SQL
0 vote193 views1 answer
Mssql unique key accept nulls
SQL