Formatting code for OracleTable
{{adsense}}
{{parent page="Oracle"}}
=== Show table size ===
%%(sql)
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';
%%
{{parent page="Oracle"}}
=== Show table size ===
%%(sql)
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';
%%