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

5 votes157 views1 answer
Oracle get nls settings
SQL
0 vote178 views1 answer
.sql File Run in PSQL
SQL
0 vote169 views1 answer
Sqlplus change user
SQL
0 vote164 views1 answer
Oracle list of long running queries
SQL
0 vote177 views1 answer
Postgres declare variable
SQL
4 votes163 views2 answers
Oracle unliock account
SQL
0 vote172 views1 answer
Oracle sql generate list of days
SQL
0 vote167 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote183 views1 answer
Apex ORA-20999
SQL
1 vote174 views2 answers
Drop function in sql
SQL