SET HEAD OFF
TRUNCATE TABLE CHAINED_ROWS
/
SPOOL ANALYZE.TXT
SELECT 'ANALYZE TABLE DATA.'||OBJECT_NAME||' LIST CHAINED ROWS;'
 FROM DBA_OBJECTS
 WHERE OWNER ='DATA'
 AND OBJECT_TYPE = 'TABLE'
/
SPOOL OFF
SET HEAD ON
@ANALYZE.TXT
SELECT TABLE_NAME,COUNT(*) FROM CHAINED_ROWS
GROUP BY TABLE_NAME
/