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.

Thanks for the clarification

Rene

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