Hi, Thank you for response.
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 Regards, Karol Bieniaszewski ----- Reply message ----- Od: [email protected] Do: <[email protected]> Temat: [firebird-support] RE: MON$IO_STATS -> MON$PAGE_FETCHES - wrong values or as designed? Data: czw., gru 12, 2013 09:38 ---In [email protected], <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
