Re: Memory Leak Oracle 8.0

Hi,

I tried your test with Oracle Client and Server 8.0.3. Yes, there is a memory leak in plus80.exe and plus80w.exe (Windowed version). But I did not find any memory leak with your test in svrmgr30.exe (Server Manager). Maybe it depends on OCI version? I do not know what OCI 7 or OCI 8 each of them uses.

And there is no any memory leak in Oracle 8.0.3 Server for NT during this test.

Andrew Protasov

> On Thu, 10 Dec 1998 02:15:45 GMT, bindu999_at_my-dejanews.com wrote:
>
> I have noticed such a leak too, at least in versions 7.2, 7.3 and 8.0.
> The leak occurs in client side, is is similar to what described here.
>
> My apps are NT services, database connection is via OCI.
>
> The leak appears to be somewhere deep in client driver's, and it can
> be easily found e.g. in SQL*PLus, too. Just write a script like
>
> connect user/pass_at_server
> disconnect
> connect user/pass_at_server
> disconnect
> connect user/pass_at_server
> disconnect
> connect user/pass_at_server
> disconnect
> ...
>
> While it goes on, the resources are lost along the way.
>
> All I could do was to stop & restart the services once a day (thus
> releasing the resources) and having enough virtual memory to be lost.
>
> >Hello,
> > We are using Oracle 8.0 For Windows NT.We have developed a multithreaded
> >application using Pro C/C++.We are noticing that for every connect to the
> >database , there is some resource leak , after the connection to the database
> >is closed.We observe that after every connect to database and connection
> >termination to the database , there is a leak of about of 1 handle and
> >40k of Virtual Memory.The increase in handles and VMSize for the
> >application , is not in step with the decrease when the connection is
> >closed.Since our application has to run as a service ,
> >we get "Running Out Of Virtual Memory" in Windows NT.
> >Can somebody explain this behaviour. Any help regarding this would be
> >very much apprciated.
> >Thanks in advance
> >bindu
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>
> BITWELL OY | Email: jari.fredriksson_at_bitwell.com
> Jari Fredriksson | Phone: +358-9-851 1105
> Nieriaisentie 6 B | Mobile: +358-40-546 3106
> 01480 VANTAA | Facsimile: +358-9-851 1150
>
>
Received on Fri Dec 11 1998 - 06:52:36 CST