set echo on;
rem ********************************************************************
rem * Author            : Rick Kupcunas
rem * Original          : 18-MAY-95
rem * Description       : Computes the size of a table
rem * Usage             : start sz_tbl_1.sql <date>  e.g. 03-MAR-95
rem *                                        <Program Name>
rem *                                        <Max run time (min.)>
rem *
rem ********************************************************************

spool sz_tbl_1.rslt;

set pagesize 60;
set linesize 132;

select greatest(4, ceil((&&NUMBER_OF_ROWS * 
        (&&LOAD_PERCENT/100.)) /
         ((round((((&&BLOCK_SIZE - 113) - (&&INITTRANS * 23)) *
          ((100 - &&PERCENT_FREE)/100.)) / &&ADJ_ROW_SIZE)))) * 2)
from DUAL;

undefine NUMBER_OF_ROWS;
undefine LOAD_PERCENT;
undefine BLOCK_SIZE;
undefine INITTRANS;
undefine PERCENT_FREE;
undefine ADJ_ROW_SIZE;

set echo off;
spool off;
commit;
