Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Is cost of explain plan reliable?
On 22 Apr 2002 07:24:51 -0700, mfowler_at_dot.co.pima.az.us (m. fowler)
wrote:
>It's recommended that DBMS_STATS be used in place of ANALYZE,
>depending on your version - let the db decide what needs to be
>analyzed, how much data to look at, how many buckets and so on.
>
On some platforms 'ANALYZE TABLE' is a fancy form of Russian Roulette,
there is bug that is sometimes hit during analyze table which
generates an ORA- error (probably 600, but I don't remember). If you
hit this bug, then there is a chance that your database will halt.
Luckily when I learned about this bug, I only had the error message.
DBMS_STATS uses a different mechanism to collect the table statistics
which is safe and 'ANALYZE INDEX' is apparently safe.
>> Run the ANALYSE command to bring the statistics up to date. Run the
>> analyse frequently enough to keep them up to date. I notice that the
>> people I work with always re-analyse everything once per day. Don't know
>> if its recommended anywhere, but that's what they do.
Received on Tue Apr 23 2002 - 12:17:28 CDT