Thanks Gabor,

can I see which queries are open in RAM?


Regards

Olaf
__________________________


Hi,

You see in task manager fbserver.exe use 500MB RAM?
Strange. When everybody disconnected the memory released?
I have only two tips. Third-party UDF problem or not closed
query-s. When you open a query the result sit on the server
until fetched all rows to the client or query closed.

I hope this helps.

Gabor

Olaf Kluge írta:

> Hello,
>
> we have a big problem with firebird 2.1.
>
> Here the gstat-statistics:
>
> Flags 0
> Checksum 12345
> Generation 23475579
> Page size 4096
> ODS version 11.1
> Oldest Trans. 23475559
> Oldest active 23475560
> Oldest snapsh. 23475560
> Next Transaktion 23475561
> Bumped Trans. 1
> Sequence No. 0
> Next attachm. ID 2063
> Implementation ID 16
> Shadow Count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Generation date Feb 5, 2009 15:03:40
> Attributes force write
>
> Sweep interval: 20000
>
> It looks fine, but the process fbserver takes hour to hour more RAM from

the

> system. From yesterday to this day increases the size from 300 Megabyte to
> 500 Megabyte. The firebird-process-size increases minutely more and more.
>
> The pagefile increases too. The problem is, that firebird jbird driver
> returns after one week of running firebird an error message, that firebird
> cannot allocate more memory.
>
> The server:
>
> 2 Gigabyte RAM,
> P4 3000
> XP pro
>
> What can be the problem? How can I find and solve it?
>
> Thanks for helping.
>
> Best regards
>
> Olaf Kluge
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.287 / Virus Database: 270.12.1/2071 - Release Date: 04/21/09
08:30:00