set echo off
--
--  Name: analyze_compute_stats.sql    
--
--  Description: Analyze and compute statistics for all tables of the current user/schema login
--
--  Usage: @analyze_compute_stats
--
set termout off
set verify off
set doc off
set feedback off
set recsep off
set pagesize 0
--
define lsize=200
set linesize &&lsize
--
define out_file=analyze_compute_stats.ddl
spool &&out_file
--
SELECT 'analyze table '||table_name||' compute statistics;'
FROM user_tables
;
spool off
set doc off
set feedback on
set pagesize 30
set termout on
set echo on
start &&out_file
-- exit