Re: Oracle managed statistics

From: Marc Blum <blum_at_marcblum.de>
Date: Fri, 02 Nov 2007 13:40:51 +0100
Message-ID: <0f6mi3tq1gmi4nf3c6p1eoljmoc1ihbe7t@4ax.com>

On Wed, 31 Oct 2007 12:00:28 -0700, Altus <silverback_at_photobooks.com> wrote:

>
>Last night it analyzed 222 objects in 8.46 minutes. This left 899
>tables and 1553 indexes analyzed before September 22

Are the 222 objects the small or the big ones?

Are we talking about 9 minutes CPU time every night vs. 1h CPU time every night?

Is this the only database on the node or are there other databases to be analyzed?

Is there any resource issue or are you trying to raise the server's idle time? Received on Fri Nov 02 2007 - 07:40:51 CDT