Re: system statistics

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 10 Oct 2003 17:26:37 GMT
Message-ID: <bm6q4c$jqg7v$1@ID-82536.news.uni-berlin.de>

 

> A couple of points:


>     do a query against sys.aux_stats$

>     to check the value of the stats, if

>     sreadtim or mreadtim is -1, then the

>     statistics will not be used.  You may

>     have collected over a period that did

>     no file system request for one or other

>     type of read.



Jonathan,
 
My sys.aux_stats$ doesn't have a sreadtim nora mreadtim column.
Has the table changed between 9.2.0.1.0 and 9.2.0.3?

   SQL> select * from v$version;    

   BANNER

---

   Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production    PL/SQL Release 9.2.0.1.0 - Production    CORE 9.2.0.1.0 Production
   TNS for Linux: Version 9.2.0.1.0 - Production    NLSRTL Version 9.2.0.1.0 - Production    

   SQL> desc sys.aux_stats$;

    Name                          Null?    Type
    ----------------------------- -------- ------------------------
    SNAME                         NOT NULL VARCHAR2(30)
    PNAME                         NOT NULL VARCHAR2(30)
    PVAL1                                  NUMBER
    PVAL2                                  VARCHAR2(255)

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch

Received on Fri Oct 10 2003 - 12:26:37 CDT