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 vote257 views1 answer
Multiple row join
SQL
0 vote125 views1 answer
Oarcale list objects
SQL
1 vote146 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
1 vote134 views1 answer
Raise application error in oracle
SQL
16 votes128 views3 answers
Delete row psql
SQL
15 votes141 views6 answers
Laravel db transaction
SQL
0 vote150 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
2 votes154 views1 answer
Find column in all stored procedures sql server
SQL
6 votes132 views1 answer
Oracle trigger after logon on schema
SQL
0 vote138 views2 answers
Change database postgres
SQL