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 vote236 views1 answer
Sql period overlap
SQL
6 votes232 views2 answers
Clear a table in mysql
SQL
6 votes256 views3 answers
Create database mysql utf8
SQL
0 vote347 views1 answer
Postgresql powershell query
SQL
0 vote232 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
3 votes222 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote244 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote251 views1 answer
Postgresql not in
SQL
10 votes246 views2 answers
What is database
SQL
3 votes369 views9 answers
Linq to sql converter online
SQL