/SQL/Query to find table size in oracle 12c

Query to find table size in oracle 12c

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

3 votes48 views1 answer
Index using in query plsql
SQL
12 votes49 views2 answers
Find duplicates mysql column
SQL
3 votes47 views4 answers
Psql list tables in schema
SQL
0 vote55 views1 answer
Sql query to return field name of a table
SQL
0 vote88 views1 answer
Creating sqeuence in oracle database
SQL
5 votes47 views2 answers
Create function postgresql
SQL
0 vote46 views1 answer
Delete * from where id = 1;
SQL
23 votes52 views1 answer
How remove column in mysql
SQL
0 vote37 views2 answers
Postgresql create role
SQL
17 votes47 views4 answers
Set mysql Password
SQL