Generate Script to Analyze on all DBA/SYS Partitioned Tables (Except AWR)
$ sqlplus -s / as sysdba < analyze_all_DBA_par_tables.sql
set head off
set linesize 150
set pagesize 1000
select 'analyze table '||t.owner||'.'||t.table_name||' partition ('||p.partition_name||
') validate structure cascade into invalid_rows;'
from user_tab_partitions p, dba_tables t
where p.table_name = t.table_name
and t.owner IN ('SYS', 'SYSTEM', 'AUD_OWNER', 'DBSNMP', 'OUTLN')
and t.table_name NOT LIKE 'WR%'
and t.partitioned='YES'
order by t.owner, t.table_name;
exit
EOF

$ cat analyze_all_DBA_par_tables.sql

analyze table SYS.STREAMS$_APPLY_SPILL_MSGS_PART partition (P0) validate structure cascade into invalid_rows;

$ sqlplus / as sysdba;
SQL> spool analyze_all_DBA_par_tables.log
SQL> @analyze_all_DBA_par_tables.sql
SQL> spool off

$ cat analyze_all_DBA_par_tables.log | grep -i "Table analyzed" | wc | awk '{print $1}'

$ cat analyze_all_DBA_par_tables.log | grep -i ORA
$ cat analyze_all_DBA_par_tables.log | grep -i "analyze table"