set echo off
----------------------------------------------------------------------------------------
--
--  Name: analyze_chained_rows.sql    
--
--  Desc: Analyze chained rows for all tables of the current user/schema login
--
--  Author: 
--
--  Usage: @analyze_chained_rows
--
--  The chained rows table must be created prior to running this script.  
--  To view the output: 
--  	select * from chained_rows;
--  	select table_name, count(*) from chained_rows group by table_name;
--
--  Revision History:
--
--  DATE       WHO		   WHAT
--  ---------  ----------  ------------------
--
--
----------------------------------------------------------------------------------------

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_chained_rows.ddl
spool &&out_file
--
SELECT 'analyze table '||table_name||' list chained rows;'
FROM user_tables
;
spool off
set doc off
set feedback on
set pagesize 30
set termout on
set echo on
start &&out_file
-- exit