Show table size
SHOW parameter block;
SELECT owner, table_name, num_rows,
BLOCKS*8192/1024/1024 AS SizeMb, empty_blocks, last_analyzed
FROM dba_tables
WHERE table_name='SOME_TABLE';
SELECT owner, table_name, num_rows,
BLOCKS*8192/1024/1024 AS SizeMb, empty_blocks, last_analyzed
FROM dba_tables
WHERE table_name='SOME_TABLE';
There are no comments on this page. [Add comment]