Re: Memory Leak Oracle 8.0

Hi,

You used orlon and ologof calls. These are OCI7 calls. And orlon call is outdated, you should use olog call instead.

OCI8 calls are completely different. Maybe there is a leak in OCI7 but not in OCI8. I will try to test.

Andrew Protasov

> Hello!
>
> Well, I tried this too, now with Server Manager, which I somehow had
> not tried before..
>
> My current Oracle version is 8.0.4 in NT 4 SP3.
>
> Yes, no leak in svrmgr80, none whatsoever. I even extended that test
> script to look like
>
> connect abba/babba_at_myserv
> select 1 from dual;
> disconnect
> ...
>
> This is because SQL*Plus does some invisible SQL and opens cursors
> 'behind curtains' when connected, and I though that Server Manager
> maybe does not. No joy, svrmgr30 still stable.
>
> I think they all should use the same OCI. Programs are linked to
> OCIW32.DLL, which in turn calls to whatever runtime is installed (so
> there's no need to relink apps when the runtime environment changes).
>
> Maybe it is so, that SQL*Plus code has a leak in it, it's not in OCI
> then.
>
> BUT, I remember that when I discovered the leak in my apps (it's maybe
> 1 year ago, I tried a simple program just connecting/disconnecting
> (just like that SQL-script, only with OCI calls orlon/ologof), the
> leak was there. Made that SQL*Plus test then, to prove the leak is not
> in my code..
>
> Have to test that again, maybe it's gone with 8.0.4!
>
> >
> >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.
> >
>
>
>
Received on Fri Dec 11 1998 - 13:26:53 CST