/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

0 vote181 views1 answer
Cannot start database server xampp mac os
SQL
7 votes138 views1 answer
Mysql remote connection command line
SQL
0 vote155 views1 answer
Gcloud sql list databases
SQL
0 vote138 views1 answer
Sql create text column limited values
SQL
3 votes143 views2 answers
How to load files in mysql
SQL
0 vote131 views1 answer
View acl table oracle
SQL
0 vote146 views1 answer
Create user faunadb
SQL
0 vote136 views1 answer
Dns slave zone convert
SQL
1 vote142 views1 answer
Db.Database.SqlQuery
SQL
2 votes143 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL