says...
>
>I recently upgraded from 7.1.4 to 7.2.2 on a DEC Unix 3.0 Alpha platform.
>The Alpha is a 4-CPU system with 640 megabytes of physical memory. The
>SGA is about
>250 megabytes, mostly buffers. When the following problems occurred,
>nothing else
>was running on the system. A query such as:
>
> select count(*) from table where date-attribute between startDate and
> endDate
>
>caused excessive page-in activity. This did not happen on 7.1.4.
Strange. Did you make any changes to the UBC? You most likely want to
minimize it. In /etc/sysconfigtab:
vm:
ubc-minpercent=1
ubc-maxpercent=2
--
Lisa Roderick
Applications Systems Engineering Performance Group
Digital Equipment Corporation
Nashua, NH
lisa.roderick_at_zko.mts.dec.com
Received on Fri Jan 05 1996 - 00:00:00 CET