Re: Huge numbers in SYS,AUX_STAT$
Date: Wed, 7 Sep 2011 15:33:02 -0700 (PDT)
On Sep 7, 5:43 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 07 Sep 2011 21:16:39 +0000, Mladen Gogala wrote:
> > This is 22.214.171.124 database, with the April PSU applied, on Linux 32bit.
> > These are the numbers I see in SYS.AUX_STATS$:
> > SQL> select pname,pval1 from sys.aux_stats$
> > 2 where pname like '%READTIM';
> > PNAME PVAL1
> > ------------------------------ ---------- SREADTIM
> > MREADTIM 72565.924
> > I thought that these were durations of an average single/multi block
> > reads, expressed in milliseconds. This doesn't work, even in
> > microseconds. Also, SREADTIM is larger than MREADTIM, which I find
> > rather strange. Has anybody noticed that? Did the units change? Should
> > I start playing with DBMS_STATS.SET_SYSTEM_STATS? Ask Tom is busy as
> > usual, impossible to ask question there.
> I should have searched Metalink, before asking the question:
> Bug 9842771 - Wrong SREADTIM and MREADTIM statistics in AUX_STATS$ [ID
> Both versions of 11.2.0 are affected. It's going to be fixed in 126.96.36.199
> and the workaround is to set it manually. This will do wonders for the
> folks who upgrades database and expects the queries to work normally.
There are apparently two related bugs, the comment by Sokrates at the
following link states that there is a patch for 9842771, but I do not
recall locating that patch:
Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Wed Sep 07 2011 - 17:33:02 CDT