query to find table size in oracle 12c

Solutions on MaxInterview for query to find table size in oracle 12c by the best coders in the world

Search
showing results for - "query to find table size in oracle 12c"
Bria
22 Apr 2016
1SELECT e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME, sum(e.bytes) / 1048576 AS Megs
2FROM dba_extents e
3WHERE
4  e.OWNER = 'SCHEME_NAME' AND
5  e.TABLESPACE_NAME = 'TBS_NAME' AND
6  e.SEGMENT_NAME IN ('TABLE_NAME')
7GROUP BY e.OWNER, e.SEGMENT_NAME, e.TABLESPACE_NAME
8ORDER BY e.TABLESPACE_NAME, e.SEGMENT_NAME;
similar questions
oracle tablespace usageoracle alter tablespace add datafile autoextend max sizeoracle calculate statistics on partitionoracle table statisticsoracle index size calculationhow to increase the width of the screen in oracleoracle calculated columnoracle get partition name by high valueoracle get table keyoracle user quota on tablespacehow to see all table partition in oracleidentify primary key in oracle tablehow to check last gather stats on table in oracleoracle index sizemake table fit in oracle sqloracle datafile max size 32gboracle table statistics last analyzedoracle schema sizesize of all tables in a schema oraclehow to know the character set of an oracle databesoracle db get table sizesoracle size of tables in schemaoracle limit user tablespaceoracle tablespace datafile max sizealter table column size oraclehow to check table lock in oracle sql developeroracle tablespace size
queries leading to this page
size of oracle tablefind table size in oraclehow to check the size of the table in oracleoracle table sizeget size of tables in oraclequery to find table size in oracle 12chow to check table size in oraclehow to find table size in oracleoracle get table sizesoracle table size queryoracle tablespace sizequery to find table size in oracle 12c