ITPub博客

使用ANALYZE命令sql>analyze table test.t3 validate structure;sql>analyze table test.t3 validate structure;使用DBVERIFY命令command>dbv blocksize=2048 file=users01.dbfcommand>dbv blocksize=8192 file=use...

select  round(sum( bytes/(1024*1024*1024)),0) "total_space GB"from    dba_data_files;