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

2 votes142 views1 answer
Install postgresql centos 5
SQL
0 vote133 views1 answer
Query builder doctrien return sql
SQL
1 vote139 views1 answer
Sql random sampling per group
SQL
0 vote136 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote134 views2 answers
SQL FROM
SQL
2 votes138 views1 answer
Removing view
SQL
1 vote142 views1 answer
Sql oracle update multiple rows
SQL
0 vote136 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
1 vote117 views1 answer
Influxdb export to csv
SQL
1 vote149 views1 answer
Get current date in pyspark sql
SQL