Re: stale statistics in KOTTD$ table

News wrote:
> These commands resolved the problem:
>
> exec DBMS_STATS.GATHER_TABLE_STATS ('SYS', 'KOTTD$')
> exec DBMS_STATS.GATHER_TABLE_STATS ('SYS', 'KOTTB$')
> exec DBMS_STATS.GATHER_TABLE_STATS ('SYS', 'KOTAD$')
> exec DBMS_STATS.GATHER_TABLE_STATS ('SYS', 'KOTMD$')
> exec DBMS_STATS.GATHER_TABLE_STATS ('SYS', 'KOTTBX$')
> exec DBMS_STATS.GATHER_TABLE_STATS ('SYS', 'KOTADX$')
>
> but
> exec DBMS_STATS.GATHER_SCHEMA_STATS ('SYS') didn't !!!!!!
>

Thanks for sharing
Seasons greetings!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...