Hi,

I'm also interested in this topic. What's the command line to get
this report ? You mean the gap between "Oldest active" and "Next
transaction" ?

Thanks, Nico

----- Original Message -----
From: "Aage Johansen" <aagjohan@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, April 20, 2004 9:37 PM
Subject: Re: [firebird-support] Re: Firebird 1.5 performance decrease in 3-4
days


On Tue, 20 Apr 2004 17:53:15 +0000 (UTC), Szakály Balázs wrote:

> This is a new gstat's report, when the server performace is poor.
> I see Oldes Active.... I think, this is a problem.
> ...
>
>
> Oldest transaction 1362491
> Oldest active 1362495
> Oldest snapshot 1362492
> Next transaction 2206316
> ...


Not good. Not at all.
Some transaction is being held open - no commit, or just CommitRetaining -
for a looong time.


--
Aage J.





Yahoo! Groups Links