Re: possible memory leak in either DBI or DBD:Oracle (or maybe oci??)
From: Roman Hochleitner (roman.hochleitner_at_ecetra.com)
Date: 03/30/04
- Next message: Robert Doucette: "Re: DBI->state()"
- Previous message: Dennis M. Gray: "RE: getting table structure out of MS-Access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Mar 2004 12:22:38 +0200 (CEST) To: Tim Bunce <Tim.Bunce@pobox.com>
On Wed, 12 Nov 2003, Tim Bunce wrote:
> On Wed, Nov 12, 2003 at 12:34:08PM +0100, Roman Hochleitner wrote:
> >
> > repeated connects to 2 or more 8.1.7 DBs OR schematas DOES leak
> > repeated connects to only ONE (or more) 9.2.0 DB DOES leak
>
> > so the conclusion could be that it looks like the problem is more/only
> > related to the DBD::Oracle module.
>
> Since connecting to a single 9.2.0 does leak, but connecting to a
> single 8.1.7 does not, *that* leak must be in Oracle's own code.
>
> > to (almost completely) rule out the assumption that the leak could be in
> > the oracle driver itself I wrote a tcl script using Tcl 8.4.4 and Oratcl 3.2.
> > any variation of connects to either 9.2.0 or 8.1.7 did NOT leak with Tcl
> > and Oratcl and as I'm an old Tcl'er I kind of find that amusing (not
> > that I want to start a flame war or something ;)
>
> The OCI API usage would be different. The key point is that exactly
> the same DBD::Oracle code leaked with 9.2.0 but not with 8.1.7.
> Since the DBD::Oracle code is the same it seems very unlikely it
> would be a leak in the DBD::Oracle code.
>
> The issue of leaks with *multiple* connects may be unrelated.
Hi,
since I still have this problem with leaking perl nocol monitors using DBI &
DBD:Oracle and I'm no perl expert, could anybody tell me how to debug this
to find out exactly where it leaks and maybe prove that it is the oracle
client itself so that I can make an official request to oracle to fix it?
thanks in advice
mfg
Roman Hochleitner
Unix System Programmer
--------------------------------------------
ecetra Central European e-Finance AG
--------------------------------------------
Neutorgasse 2 | A-1010 Vienna
Tel: +43-1-536 89-17725
Fax: +43-1-536 89-17719
http://www.ecetra.com
- Next message: Robert Doucette: "Re: DBI->state()"
- Previous message: Dennis M. Gray: "RE: getting table structure out of MS-Access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
