Re: Forms memory leak....(?)
Date: 28 Mar 94 18:53:07 GMT
Message-ID: <27542_at_uswnvg.uswnvg.com>
Jonathan Lemon (jlemon_at_netcom.com) wrote:
: I'm seeing some annoying (!) behavior with Oracle/Forms, and was wondering
: if anyone else has had a similar problem.
: We have a large forms hierarchy, where the users can start up a single
: runform instance, and then execute many different forms. What we're
: seeing is that after a user has been working for a few hours and visited
: quite a few forms, the processes' DATA+BSS segment has gotten quite huge.
Welcome to the club! Ours is not quite THAT bad, probably because our Apps programmers have pulled some tricks to minimize the problem. One thing you might want to look at is open cursors - there are a bunch of "memory leaks" in and around cursor handling, and we found that if you make SURE to explicity close cursors, SOME of the problems go away.
The latest word we have out of support is "fixed in 7.0.16", which we're going to start installing later this week. If you send me your email address, I'll send you back some results, although I expect what we're going to see is more "Out of Memory" messages rather than a real fix. Received on Mon Mar 28 1994 - 20:53:07 CEST