Re: Memory Leak Oracle 8.0

Hi,

I think that you can find ProC from Oracle 7.3 and use it with Oracle 8 client software.

Andrew Protasov

> Hi,
> Thanks for the efforts taken. But Pro C/C++ doesn't generate calls to OCI.
> How can i fix the problem.
> Thanks a lot for the help
> bindu
>
> In article <ABkfQSsK42_at_protasov.kiev.ua>,
> oracle_at_protasov.kiev.ua wrote:
> >
> > Hi,
> >
> > I just finished my tests. So the result is - there is NO
> > memory leak in OCI7 implementation of Oracle 8.0.3 client
> > for NT and there IS a memory leak in OCI8 implementation of the
> > same client. This is the reason why Server Manager works
> > correctly (OCI7) but SQL Plus has memory leak (OCI8).
> >
> > This OCI7 test source:
> >
> > #include <stdio.h>
> > #include <stdlib.h>
> > #include <string.h>
> > #include <oratypes.h>
> > #include <ocidfn.h>
> > #include <ociapr.h>
> >
> > struct cda_def lda;
> > unsigned char hda[512];
> >
> > int checkerr(struct cda_def *lda,int i);
> > int main(int argc,char **argv)
> > {
> > int i=0,j,k;
> > if(argc!=5)
> > printf("testcon7 <username> <password> <sqlnetalias> <iterations>\n");
> > else
> > {
> > k=atoi(argv[4]);
> > for(j=1;j<=k;j++)
> > {
> > memset(&lda,0,sizeof(lda));
> > memset(&hda,0,sizeof(hda));
> >
> if(i=checkerr(&lda,olog(&lda,hda,argv[1],-1,argv[2],-1,argv[3],-1,OCI_LM_DEF)))
> goto err1;
> > printf("Connect iteration %d\n",j);
> > if(i=checkerr(&lda,ologof(&lda))) goto err1;
> > }
> > }
> > err1: return i;
> > }
> > int checkerr(struct cda_def *lda,int i)
> > {
> > char errbuf[1024];
> > if(i)
> > {
> > oerhms(lda,(short)i,errbuf,sizeof(errbuf));
> > printf("Error %s",errbuf);
> > }
> > return i;
> > }
> >
> > This is OCI8 test source:
> >
> > #include <stdio.h>
> > #include <stdlib.h>
> > #include <string.h>
> > #include <oci.h>
> >
> > #define anderror(i,j) ((i)=(i)?(i):(j))
> >
> > static OCIEnv *envhp;
> > static OCIError *errhp;
> > static OCIServer *srvhp;
> > static OCISvcCtx *svchp;
> > static OCISession *authp;
> >
> > int checkerr(OCIError *errhp,int i);
> >
> > int main(int argc,char **argv)
> > {
> > int i=0,e,j,k;
> > if(argc!=5)
> > printf("testcon7 <username> <password> <sqlnetalias> <iterations>\n");
> > else
> > {
> > if(i=OCIInitialize(OCI_DEFAULT,NULL,NULL,NULL,NULL)) goto err99;
> > if(i=OCIEnvInit(&envhp,OCI_DEFAULT,0,NULL)) goto err99;
> > if(i=OCIHandleAlloc(envhp,&errhp,OCI_HTYPE_ERROR,0,NULL)) goto err98;
> > if(i=OCIHandleAlloc(envhp,&srvhp,OCI_HTYPE_SERVER,0,NULL)) goto err97;
> > if(i=OCIHandleAlloc(envhp,&svchp,OCI_HTYPE_SVCCTX,0,NULL)) goto err96;
> > k=atoi(argv[4]);
> > for(j=1;j<=k;j++)
> > {
> > authp=NULL;
> >
> if(i=checkerr(errhp,OCIServerAttach(srvhp,errhp,argv[3],strlen(argv[3]),OCI_DEFA
> ULT))) goto err95;
> >
> if(i=checkerr(errhp,OCIAttrSet(svchp,OCI_HTYPE_SVCCTX,srvhp,0,OCI_ATTR_SERVER,er
> rhp))) goto err94;
> > if(i=OCIHandleAlloc(envhp,&authp,OCI_HTYPE_SESSION,0,NULL)) goto err94;
> >
> if(i=checkerr(errhp,OCIAttrSet(authp,OCI_HTYPE_SESSION,argv[1],strlen(argv[1]),O
> CI_ATTR_USERNAME,errhp))) goto err93;
> >
> if(i=checkerr(errhp,OCIAttrSet(authp,OCI_HTYPE_SESSION,argv[2],strlen(argv[2]),O
> CI_ATTR_PASSWORD,errhp))) goto err93;
> >
> if(i=checkerr(errhp,OCISessionBegin(svchp,errhp,authp,OCI_CRED_RDBMS,OCI_DEFAULT
> ))) goto err93;
> >
> if(i=checkerr(errhp,OCIAttrSet(svchp,OCI_HTYPE_SVCCTX,authp,0,OCI_ATTR_SESSION,e
> rrhp))) goto err92;
> > printf("Connect iteration %d\n",j);
> > err92: e=checkerr(errhp,OCISessionEnd(svchp,errhp,authp,OCI_DEFAULT));
> anderror(i,e);
> > err93: e=OCIHandleFree(authp,OCI_HTYPE_SESSION); anderror(i,e);
> > err94: e=checkerr(errhp,OCIServerDetach(srvhp,errhp,OCI_DEFAULT));
> anderror(i,e);
> > if(i) goto err95;
> > }
> > err95: e=OCIHandleFree(svchp,OCI_HTYPE_SVCCTX); anderror(i,e);
> > err96: e=OCIHandleFree(srvhp,OCI_HTYPE_SERVER); anderror(i,e);
> > err97: e=OCIHandleFree(errhp,OCI_HTYPE_ERROR); anderror(i,e);
> > err98: e=OCIHandleFree(envhp,OCI_HTYPE_ENV); anderror(i,e);
> > }
> > err99: return i;
> > }
> > int checkerr(OCIError *errhp,int i)
> > {
> > char errbuf[1024];
> > if(i&&!OCIErrorGet(errhp,1,NULL,&i,errbuf,sizeof(errbuf),OCI_HTYPE_ERROR))
> > printf("Error %s",errbuf);
> > return i;
> > }
> >
> > You may try this with newer Oracle client software.
> >
> > 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.
> > > >
> > >
> > >
> > >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
Received on Mon Dec 14 1998 - 06:11:59 CST