Subject | Re: firebird allocates suddenly a lot of memory and causes XP to swap |
---|---|
Author | michel_messner |
Post date | 2006-03-09T16:08:17Z |
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*
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
>