Re: Analyze table timing

From: broom <broom_at_voicenet.com>
Date: 18 Sep 2001 10:07:17 -0700
Message-ID: <c948eb61.0109180907.59ff33d5@posting.google.com>

Koert Wrote:
> Oh btw - killing an analyze in 8i often comes with an ORA600 ... it will not
> crash the DB but, hey, as most
> of us I'm not too very fond of those ORA600's in the alert log...
>

Yup. Just discovered this. Used 'alter session' which also left a latch on a partition which hung the next try.

I think I'll bounce the instance and use the dbms_stats.

Thanks.

Barry Received on Tue Sep 18 2001 - 12:07:17 CDT

This message: [ Message body ]
Next message: Ben: "Controlling multiple database connections as one transaction."
Previous message: Burghard W.V. Britzke: "Installation Problem Oracle 8.1.7 on SuSE 7.2 Linux distr."
In reply to: koert54: "Re: Analyze table timing"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US