Re: Updating system statistics

From: Don Seiler <don_at_seiler.us>
Date: Tue, 12 Dec 2006 14:02:56 -0600
Message-ID: <716f7a630612121202p79f20674yc61d54bd64119bb4@mail.gmail.com>

Alright I ran this command:

exec dbms_stats.gather_system_stats(interval=>90,stattab=>'SYSSTATS',statid=>'DEC12');

It returned in a minute, so I assume that it runs in the background now. I've noticed two rows in my SYSSTATS table, but the column names are a bit unintuitive. Is there a HOWTO on interpreting that data?

Don.

On 12/12/06, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
>
> > So gathering system stats to the user table won't alter CBO behavior
> > then? I assume I have to create that table with
> > dbms_stats.create_stat_table() function.
>
> Exactly.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 12 2006 - 14:02:56 CST