Subject RE: MON$IO_STATS -> MON$PAGE_FETCHES - wrong values or as designed?
Author

---In firebird-support@yahoogroups.com, <liviuslivius@...> wrote:


> In MON$IO_STATS - MON$PAGE_FETCHES field i see reads 120637 pages but my whole test database have only 6685 pages.
> Is something wrong with counters when status of statement is 2 in field MON$STATE?

  Your page cache is definitely less than 6685, so some pages could be read from disk many times...

Regards,
Vlad