Re: When and How to run dbms_stats.gather

"Andras Kovacs" <andkovacs_at_yahoo.com> wrote in message news:412ebb69.0308181818.15b71440_at_posting.google.com...
> Okay the question wasn't clear.
> You have too much imagination.
>
> Should users be logged off when running dbms_stats ?
> Or can we run dbms_stat during normal cycle of operations ?
>
> Ask the same from Oracle you will get as many answer as they have
> customer analysts ....

You would normally run it off peak hours. You can run it during the normal cycle of operations, however there are downsides to that: * One being that if analyzing causes any problems, you'd rather be fixing it off peak hours. * Another being that analyzing invalidates any reference to the objects being analyzed, causing them

   to be re-parsed. Thus you might not want to analyze while your site/db is showing peak activity. * Analyze itself uses resources depending on how much data is being analyzed (estimate factor etc),

   so just like a batch operation, its preferable to do it off-peak hours.

Now about your original problem: Oracle crashing when you do analyze... maybe you did not explain that either. Or maybe you want us to use our imagination there also. By crashing you mean the database just goes belly up? No errors/trace files/alert messages? I'd admit I've never really seen that happening ... You also did not state what exactly are you analyzing (db/schema/bunch of tables), nor have you stated your Oracle version, error messages ...

Anurag Received on Mon Aug 18 2003 - 23:41:33 CDT