Re: stats document links.
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 22 Mar 2011 20:55:13 -0700
Message-ID: <AANLkTi=jiB6MYp_Z26B_tmYumZ12GAhWrkBnb5ph1Nf6_at_mail.gmail.com>
Greg Rahn's blog has some good links/articles. I have seen articles in his blog where he stresses on the importance of stats being representative of the data.
On a lighter note, I was in similar situation earlier and one of the 'Directors' asked us to collect stats everyday even for a table such as fnd_lookups (data is pretty much static except for big FND patches) - in an apps situation. When I told him stats should be representative and not collected for the sake of collection, he was mad at me and complained to my manager :).
Date: Tue, 22 Mar 2011 20:55:13 -0700
Message-ID: <AANLkTi=jiB6MYp_Z26B_tmYumZ12GAhWrkBnb5ph1Nf6_at_mail.gmail.com>
Greg Rahn's blog has some good links/articles. I have seen articles in his blog where he stresses on the importance of stats being representative of the data.
On a lighter note, I was in similar situation earlier and one of the 'Directors' asked us to collect stats everyday even for a table such as fnd_lookups (data is pretty much static except for big FND patches) - in an apps situation. When I told him stats should be representative and not collected for the sake of collection, he was mad at me and complained to my manager :).
- Kumar
On Tue, Mar 22, 2011 at 10:18 AM, <Joel.Patterson_at_crowley.com> wrote:
> I use default stats collection method on 10.2.0.4 database. I get
> questioned (via email) about someones attention being drawn to the fact that
> many tables have not had stats collected in months, and some have had them
> recently.
>
> Does anyone off hand have some nice links I an send these people, I
> believe this last on is a project manager type.
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 22 2011 - 22:55:13 CDT