/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 vote136 views1 answer
How to locate pg_hba.conf file
SQL
3 votes121 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
9 votes140 views3 answers
Import DB through mysql console
SQL
10 votes150 views4 answers
Inner join in update query mysql
SQL
0 vote130 views2 answers
Identity column in sql server
SQL
48 votes212 views3 answers
Psql create database
SQL
10 votes123 views1 answer
Query to find object dependencies in oracle
SQL
4 votes149 views2 answers
Dbms output
SQL
0 vote125 views1 answer
What is SQL data store?
SQL
4 votes121 views4 answers
Print pl sql
SQL