/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

1 vote225 views2 answers
Sql now - 1 day
SQL
3 votes195 views1 answer
Increment integer in table sql
SQL
0 vote190 views1 answer
Setval in postgres
SQL
25 votes183 views3 answers
How to use a database to see tables mysql
SQL
0 vote227 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote185 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote194 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote210 views1 answer
Into operator in sql
SQL
7 votes186 views1 answer
Postgres base size
SQL
0 vote201 views1 answer
Sql server on mac m1
SQL