On Wed, 18 Dec 2002 12:16:11 -0600 "Zhou, Bixia" <[EMAIL PROTECTED]> wrote:
> I moved declare $dbh out of loop as you suggested, but memory usage didn't > stop to grow. There may be a leak somewhere, but someone else will have to find it. When I had a perpetual script like this, I had it exit after 24 hours and had a new copy started every day by the system. That should at least bound the memory loss. > -----Original Message----- > From: Michael A Chase [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 11:56 AM > To: '[EMAIL PROTECTED]'; Zhou, Bixia > Subject: Re: dbi help > > > On Wed, 18 Dec 2002 11:08:14 -0600 "Zhou, Bixia" <[EMAIL PROTECTED]> > wrote: > > > We are currently using: perl, v5.8.0 built for MSWin32-x86-multi-thread > > The test code as following: > > my $process = 1; > > while ($process){ > > my $dbh = DBI->connect('dbi:Oracle:sid', $user, $pass, { AutoCommit > => > > 0 > > }); > > if ($dbh =~ /ERR/) > > { > > exit; > > } > > $dbh->disconnect; > > undef $dbh; > > sleep(10); > > } > > The memory usage starts at 9mb and keeps up. Anybody notices this > before? > > and has a solution? -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
