Subject Re: firebird allocates suddenly a lot of memory and causes XP to swap
Author michel_messner
Hi!

these are my DB-Stats after this things happened. My app crashed this
time and I had to kill it with taskmanager. But the seem fine to me.

Database "D:\wps3\Laufzeitumgebung\DB\db.fdb"

Database header page information:
Flags 0
Checksum 12345
Generation 147682
Page size 4096
ODS version 10.1
Oldest transaction 147671
Oldest active 147672
Oldest snapshot 147672
Next transaction 147673
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 1028
Next header page 0
Database dialect 3
Creation date Mar 9, 2006 15:05:09
Attributes force write, no reserve

Variable header data:
Sweep interval: 0
*END*

--- In firebird-support@yahoogroups.com, "diwic2" <diwic2@...> wrote:
>
> --- In firebird-support@yahoogroups.com, "michel_messner" <Messner@
> > wrote:
> >
> > OIT/OAT is ok, the difference is allways 1. As I wrote in my first
> > post the transaction logic of my application is ok.
>
> If there is any larger difference between any of OIT, OAT, "oldest
> snapshot" and "Next transaction" there is reason to believe there is
> some trouble in the transaction logic.
>
> // David
>