Formatting code for OracleTable


show source only

{{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';
%%
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki