ho rm analyze.tmp.sql
spool analyze.tmp.sql
set heading off
select 'prompt >processing: '
||table_name
||chr(13)
||'select to_char(sysdate,''MM/DD/YY HH24:MI:SS'') from dual;'
||chr(13)
||'execute dbms_stats.gather_table_stats(ownname => user, tabname => '''||table_name||''', degree => 4, cascade => true);'
||chr(13)
||'select to_char(sysdate,''MM/DD/YY HH24:MI:SS'') from dual;' from user_tables where table_name<>'BIG_TABLE';
spool off
@analyze.tmp.sql
ho rm analyze.tmp.sql