memory scan rate on host box
4 databases 10.2.0.3
vmstat every so often shows the memory page scan rate going through the roof which occasionally brings the box to a standstill.
the problem we are having is marrying up the scan rate usage to a process or indeed a series of processes.
There does not appear to be any unusual activity in the databases. Nor can see how rogue processes or again something unusual.
We have tracked when the issue first started (begining of the month) using grid, and are currently trying to ascertain what has changed on the system. But fundamentally if we can see what process(es) are casuing the scan rate to ramp up we'd have a better idea.
Does anyone know how to do this?