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 vote220 views1 answer
Sql database size
SQL
0 vote243 views1 answer
Drop-toys-table
SQL
18 votes225 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
2 votes175 views1 answer
Oracle current date without time
SQL
10 votes227 views2 answers
Sql merge statement
SQL
0 vote186 views1 answer
Java spring boot connect to sql server
SQL
0 vote216 views1 answer
Ffeathers express mysql application users login
SQL
3 votes218 views1 answer
Oracle get trigger ddl
SQL
0 vote230 views1 answer
Gcloud sql instance list
SQL
1 vote217 views3 answers
Rename table snowflake
SQL