Re: system statistics

Rene Nyffenegger wrote:

>
>
>
>>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
>
>

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 10 11:44:31 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production

SQL> desc aux_stats$

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

SQL>

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)