Re: Is gradually increasing memory in long running session normal? (Resolved)

dthacker@omnihotels.com (Dave Thacker) wrote in message news:<554c618d.0309041255.4b687882@posting.google.com>... > I've been trying to debug a problem with a constantly running > application that is > experiencing a performance degradation over time. Today I set up a > script to > run onstat -g ses every 60 seconds and log the results. One of the > things that caught my eye is that this session's memory use increases > constantly over time. > For example, > > total > memory > 13:38 1265664 > 14:38 1977408A > 15:38 2646016 > > Will the total memory ever decrease during the lifespan of a session? > A short followup to this question. After we received the feedback in the previous posts we started looking closely at the code for this application. We found several cursors that were not freed in the code. I think it's important to note that the code, however flawed, had been in production for months and ran under the 7.31UC6 engine with no problems. When we upgraded to 9.30, the same code would gradually run slower and slower until it ground to halt. Restarting the app would fix the problem...for a while. We had both our programming staff and IBM consulting look at the offending program and found we had cursors that were declared with hold and were not freed. According to our consultant this is an issue with 9.3 but is "fixed" in 9.4 We changed the program to declare the cursors without hold, as the hold feature was not needed and freed the cursors. After the changes were made, the memory issue was resolved. Regards, Dave Thacker