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?
>
It's stored as rows of data instead of columns. The column PNAME will
have the values 'SREADTIM', 'MREADTIM', etc...
--
Richard Kuhler
Received on Fri Oct 10 2003 - 13:59:32 CDT
