Skip to Content
Former Member
Jun 26, 2007 at 01:41 AM

"Last analyze" of Table DBA_TAB_COLUMNS has not been updated


Recently PRD system's performance became worse.

And I look for some trace, I found statics has not been updated since 12/08/2006.

ex; "Last analyze" of Table DBA_TAB_COLUMNS

I can't understand why this situation happend, because we have excuted command "brconnect -u / -c -f stats -t all" weekly.

And we did migration last Aug.

That is exactly last statics was updated.

At that time, we changed Oracle version( 8 → 9), Hardware(Server, EMC).

If someone experiences that problem or similar one, please tell me the reason and how to act.

Please help on this.