Memory Leak with Failover Feature enabled

From: Thomas Winter <winter_at_osiag.de>
Date: 6 Jun 2002 09:20:02 -0700
Message-ID: <808ed67f.0206060820.1dcb8e30_at_posting.google.com>


Hello NG,

we have a serious memory leak while using the following environment:

  • Multithreaded program (up to 30 Threads)
  • Database access from all Threads, only OPEN & CLOSE via ODBC
  • Oracle 7.1 Client
  • Windows 2000 Terminalserver
  • Programm connects via ODBC

Test cases:

  • SQLNET configuration with two name servers and two servers (Failover) --> big mem leak
  • TNSNAMES configuration with two servers (only failover, no name server) --> mem leak
  • TNSNAMES configuration with only one server --> no mem leak

btw: if i start the test with only one thread (more than 100 loops)

     there is no memory leak.
     And i run the same program using a Sybase Sql Anywhere Database
     i have no mem leak with 30 Threads.

On Request i could send you the source of the testprogram.

Any suggestions?

P.S. Found a articel in the oracle bug database, that seemed to be

     a similar (the same?) problem. But i'm not sure.

Link to orcale bug database:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=2129808

Thanks for any help

Thomas Winter
winter_at_osiag.de Received on Thu Jun 06 2002 - 18:20:02 CEST

Original text of this message