Re: system statistics

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sat, 25 Oct 2003 14:49:03 +0300
Message-ID: <3f9a6330$1_1@news.estpak.ee>

Hi!

SREADTIM is a column value for PNAME column. You have to read PVAL1 column from AUX_STATS$ table.

Tanel.

"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message news:bm6q4c$jqg7v$1_at_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 Sat Oct 25 2003 - 06:49:03 CDT