set head off
spool tablestat.txt
select 'ANALYZE TABLE '||OWNER||'.'||OBJECT_NAME||'  COMPUTE STATISTICS;'
FROM DBA_OBJECTS WHERE OWNER = 'DATA' AND OBJECT_TYPE
='TABLE'
ORDER BY OBJECT_NAME
/
SPOOL OFF
SET HEAD ON
@TABLESTAT.TXT
set head off
spool indexstat.txt
select 'ANALYZE INDEX '||OWNER||'.'||OBJECT_NAME||'  COMPUTE STATISTICS;'
FROM DBA_OBJECTS WHERE OWNER = 'DATA' AND OBJECT_TYPE
='INDEX'
ORDER BY OBJECT_NAME
/

SPOOL OFF
SET HEAD ON
@INDEXSTAT.TXT