| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: stale statistics in KOTTD$ table
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 !!!!!!
Received on Thu Dec 22 2005 - 07:43:58 CST
 |
 |