Re: Verify Outdated Optimizer Stats
From: joel garry <joel-garry_at_home.com>
Date: Tue, 17 Feb 2009 17:26:51 -0800 (PST)
Message-ID: <984a7640-44fc-4bda-8316-e4fd814db014_at_q40g2000prh.googlegroups.com>
On Feb 16, 8:55 pm, Ram <krishna..._at_gmail.com> wrote:
> Hi All,
>
> I hope every one would have come across that users complaining about
> the response of database.Usually the first thought comes to the DBA
> is to Gather Stats and verify the performance.Performance will be far
> better after collecting stats and this is expected behavior.
>
> Before users start complaining about the performance of database is
> very slow , Can't we verify the statistics for out database is that
> outdated. Can any one throw some light on this .
>
> Regards
>
> RAM.
And check this out: http://structureddata.org/2009/02/16/managing-optimizer-statistics-paper/
Date: Tue, 17 Feb 2009 17:26:51 -0800 (PST)
Message-ID: <984a7640-44fc-4bda-8316-e4fd814db014_at_q40g2000prh.googlegroups.com>
On Feb 16, 8:55 pm, Ram <krishna..._at_gmail.com> wrote:
> Hi All,
>
> I hope every one would have come across that users complaining about
> the response of database.Usually the first thought comes to the DBA
> is to Gather Stats and verify the performance.Performance will be far
> better after collecting stats and this is expected behavior.
>
> Before users start complaining about the performance of database is
> very slow , Can't we verify the statistics for out database is that
> outdated. Can any one throw some light on this .
>
> Regards
>
> RAM.
And check this out: http://structureddata.org/2009/02/16/managing-optimizer-statistics-paper/
jg
-- _at_home.com is bogus. http://kerryosborne.oracle-guy.com/2008/12/oracle-fudge/Received on Tue Feb 17 2009 - 19:26:51 CST