Re: How to know the stats is corrupted

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Tue, 30 Apr 2013 16:26:15 +0530
Message-ID: <CAEq4C0cODOxOTv_S6pfPONWg3NPg66jLzWovmwg57Zcf5E2XcA_at_mail.gmail.com>

Hi Kart,
I presume you are not stating a dictionary corruption but a performance problem....guessed to coming from corrupt stats?

what is the DB and platform version and when you say corrupt behaviour...what happens do you see execution plans changing once/random/unpredictable?. Have you looked at the execution plans ( not explain plans) of the SQL's?. what is the data that you have collected  that you could share or is there a test case that you you could share

best regards

sriram

On Tue, Apr 30, 2013 at 3:45 PM, K R <kp0773_at_gmail.com> wrote:

> Hi,
> At times when the performance goes slow some of DBA in our team says that
> the stats get corrupted . asking how do you determine dont bring any good
> explanation.
>
> Anyone please throw some insights on it .
>
> thanks
> Kart
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Apr 30 2013 - 12:56:15 CEST