You have to change the parameter in the init.ora file on the db server and
bounce the db instance or have your client do this.
This is a memory leak on the db server but any connection to the db,
including remote connections, can cause the problem.
HTH
Gerardo
-----Original Message-----
From: Mickey Mestel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 12, 2001 2:39 PM
To: Molina, Gerardo
Cc: Dbi-Users@Perl. Org
Subject: Re: Oracle memory leak
derardo,
> This might be the same issue we ran into just this week.
>
> According to Oracle Support, this is Bug 1397603, which is supposed to be
> fixed in 8.1.7.2, which isn't out yet, of course.
>
> Try the following workaround:
correct me if i'm wrong here, but won't this only affect things on the
server side? this looks like it would take care of a memory leak on the
system where the oracle engine is running, but not on a remote system where
something like a perl dbi script is running.
let me know if this is not the case. i don't know when i would be able
to try this anyway. we do remote monitoring of oracle databases, so with
something like an init.ora parameter i would have to have our client make
the change and bounce the engine.
let me know about this though.
thanks,
mickm
