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

6 votes324 views2 answers
Postgresql restore from dump
SQL
2 votes338 views1 answer
Q operator in plsql
SQL
0 vote324 views1 answer
Sql select random procentage from rows
SQL
1 vote353 views1 answer
Show databases mysql docker
SQL
0 vote258 views1 answer
Microsoft sql server management studio clear cache
SQL
8 votes338 views2 answers
Phpmyadmin default password
SQL
4 votes306 views2 answers
Mysql select where starts with
SQL
5 votes298 views3 answers
Truncate function in sql oracle
SQL
1 vote342 views1 answer
Mamp mysql path mac
SQL
0 vote334 views1 answer
Mysql last 6 months
SQL