SET PAGESIZE 0
SPOOL SAIDA.TXT
SELECT 'ANALYZE TABLE '||OWNER||'.'||TABLE_NAME||' DELETE STATISTICS;'
FROM DBA_TABLES
WHERE BLOCKS IS NOT NULL
AND OWNER='USER'
ORDER BY TABLE_NAME
/
SPOOL OF