Analyze table takes very long time
Hi all !
Every month we execute the analyze table statement on our application schema tables (v 7.3.4 on RS6000).
It takes more and more time ... about 5-6 hours today.
Is it normal ?
Does anyone has ever encountered this problem ?
Thanks a lot in adavance for your replies ...
Re: Analyze table takes very long time
Quote:
Originally posted by htanga
Hi all !
Every month we execute the analyze table statement on our application schema tables (v 7.3.4 on RS6000).
It takes more and more time ... about 5-6 hours today.
Is it normal ?
Does anyone has ever encountered this problem ?
Thanks a lot in adavance for your replies ...
Use DBMS_STATS, set table MONITORING and analyze only the STALE tables.
Re: Re: Analyze table takes very long time
Quote:
Originally posted by julian
Use DBMS_STATS, set table MONITORING and analyze only the STALE tables.
DBMS_STATS? Table MONITORING? In Oracle 7.3 ???