[Info-Ingres] Cache hit ratio 20% ummm is that good?

[Steve McElhinney]

On Nov 15, 2:44 pm, Karl & Betty Schendel <schen... at kbcomputer.com>
wrote:
> At 3:01 PM +1000 11/15/07, Paul White wrote:
[snip]
> Roy's point about the meaning of GREAD is entirely valid.
> My best recollection is that it got changed from
> operations to pages sometime in the 2.6 service packs,
> and got changed back maybe around 3.0.3, or 9.0.4.
> The current situation (from memory, haven't looked at the
> code) is that the page size summary GREAD is operations,
> but the individual page type GREAD is pages!
>
> Karl

Use of GREADS & GWRITES values in dm420 output changed in 2.6/0305
(Service Pack 2)

I have a CA document titled "Trace Point DM420 Output Explained" from
Sept 2003 which states:

"Note: The information provided in this document does not apply to
other releases of Advantage Ingres.
The output for this version of Advantage Ingres may appear to be the
same as the output for other releases,
but the values are derived in a different way. For example, in earlier
versions of Advantage Ingres,
GREADS and GWRITES were counts of the number of GROUPS written and
read.
For Advantage Ingres 2.6/0305 (Service Pack 2), the values denote the
number of PAGES within
groups written and read."

HTH
Steve