RE: How to know the stats is corrupted

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Tue, 30 Apr 2013 12:56:13 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD1186AACAF_at_G6W2491.americas.hpqcorp.net>

K R, I do not think "corrupt" is the right term. If the statistics in question were actually corrupt I would expect that an error to be thrown and you did not post any error messages. Perhaps you mean the optimizer statistics are stale or otherwise inaccurate?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K R Sent: Tuesday, April 30, 2013 6:15 AM
To: Oracle-L_at_freelists.org
Subject: How to know the stats is corrupted

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 - 14:56:13 CEST