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 vote363 views1 answer
Mysql utc timestamp
SQL
57 votes599 views6 answers
Mysql alter table add column
SQL
3 votes381 views4 answers
Ubuntu stop mysql
SQL
3 votes360 views2 answers
Sql paging query
SQL
0 vote382 views1 answer
Stored procedures example
SQL
4 votes430 views1 answer
Mysql store ip address
SQL
15 votes390 views6 answers
Laravel db transaction
SQL
0 vote374 views1 answer
Sql select lowest value row
SQL
32 votes385 views6 answers
Insert select
SQL
0 vote361 views1 answer
Sql create text column limited values
SQL