Interbase and Memory usage
Ang Lik Huar
Hi there,
I have an system which run under interbase(ver 6.0.1) and normally around 5-6 user use the system.
While running, the interbase server memory keep on increasing and it also consume a lot of CPU resources(monitor thru task manager). After 3-4 hours, the system will prompt "Out of memory".
The sweep interval is set to 2000 and i have increase the virtual memory. The database has been swept and backup/restore. Problem still occur.
Any one have idea why suddenly the interbase will consume so much memory and cpu resources ?
Thanks very much !
Regards,
Ang Lik Huar
Wayne Niddery [TeamB]
news:3ea3edb3$1...@newsgroups.borland.com...
This almost always indicates a problem with the application leaving
transactions open too long. After running for a couple of hours, but before
your system runs out of memory, get the statistics from the database (you
can get these from IBConsole). You can post those here - the key items are
oldest and next transaction numbers.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
Powered by Delphi and Interbase:
http://www.logicfundamentals.com/RadBooks.html
"Democracy, without that guarantee of liberty, is merely a method of
selecting tyrants." - Alan Nitikman
Ang Lik Huar
Hi Wayne Niddery,
Does it means that, if the number between oldest and next transaction numbers is very large, then they must be some transaction holding there and never being commited ?
Regards,
Ang Lik Huar
Bill Todd
On 21 Apr 2003 08:36:39 -0700, "Ang Lik Huar" <an...@asistech.com.sg>
wrote:
>
>Hi Wayne Niddery,
>
> Does it means that, if the number between oldest and next transaction numbers is very large, then they must be some transaction holding there and never being commited ?
Yes. It would help if we could see the header statistics, particularly
the oldest transaction, the oldest active transaction and the next
transaction.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)