Re: system statistics

Sorry,

I was being too casual in my description.

    pname = 'SREADTIM'
is the row

    pvalue = {milliseconds for a single block read}

When the stats are live, you need to view the rows where sname = 'SYSSTATS_MAIN' (I think, I'm working from memory) - but there are some rows which describe the state of the statistics, and some which give the actual values.

In 9.2, the useful pname values are:

    MBRC
    SREADTIM
    MREADTIM
    CPUSPEED (in MHz - but mine is NEVER right)     SLAVETHR (for throughput)
    ????THR (I can't remember what the principla throughput

        figure is called).

You may find pval2 = 'BADSTAT' (or possibly 'BADSTATS', in which case cpu_costing won't be invoked). There is also a hidden parameter which can be set to enable/disable it - the default value varies from 9.0 to 9.2 I think.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Iceland__November (tbc)
____Belgium__November (EOUG event)
____UK_______December (UKOUG conference)


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"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