Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus memory leak?

Re: sqlplus memory leak?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 26 Jun 2003 16:23:58 +0200
Message-ID: <bdevnr$pr8$1@dackel.pdb.sbs.de>


Pim wrote:
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> news:<bdcmuu$gfk$1_at_dackel.pdb.sbs.de>...
>> But wouldn't that script point to a memory leak in your shell?
>> Or are you connecting locally and the server process leaks?
>> Anyway, sqlplus can't leak much from one statement and any
>> possible leak will disappear with the finishing of the process.
>> i.e. with the "/" in your script.
>>
>> Lots of Greetings!
>> Volker
>
> The problem however is that the memory is not freed when no scripts
> are active. Rebooting the computer seems to be the only remedy to
> reclaim mem.

*WHICH* memory??? You could make it a lot easier for all of us if you figured that out.

Lots of Greetings!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"
Received on Thu Jun 26 2003 - 09:23:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US