Subject Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed?
Author liviuslivius@poczta.onet.pl
Hi,

Thanks you very much i see that i misunderstand fetches fetchesield previously. Now it is clear - for 59732 records it is possible to have 120637 fetches :)

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: hvlad@...
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed?
Data: czw., gru 12, 2013 14:52


 


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


> My pagesize is 16k and pages cache is set to 65536. And this can not be that.
> I see in MON$PAGE_READS small value = 585 but in MON$PAGE_FETCHES value = 120637.
> Database have 6685 pages what is corelated with real db size = ~104MB

  Oops, i mixed reads vs fetches :) Fetch is access to the page in page cache. To process (select)
one *row*, Fierbird need to make 2 fetches at least, for example. So, i see nothing strange here.

Regards,
Vlad