Re: Oracle Memory leakage

Rok Kodrun wrote:

> Oracle Memory leakage
>
> I have a Oracle7.3 workgroup server on Win NT 4.0 SP 6 which is using more
> and more memory - in two days it fills up all the system memory (64mb) and
> virtual memory.
>
> After reboot no other application is runing except from ORACLE server (and
> there are no other apps connected to Oracle server). Using NT Performance
> Monitor I checked Private Bytes & Virtual Bytes usage of ORACLE73.EXE
> process. Memory usage is gradually raising until it fills up all the
> resources!!
>
> I checked the sessions on the server, there are none other then those few
> system sessions.
> I also checked the V_OPEN_CURSORS view, and it shows no open cursors (except
> itself).
>
> Any idea what's going on? Has anybody ever encountered same sort of
> problems? Any other solution than reinstalation of NT/Oracle server?
>
> Rok Kodrun
> CT2
> "Jo¾ef Stefan" Institute
> Slovenia

You have Oracle on an operating system for which it was never intended or approved. The workaround is to get yourself a copy of version 8.1.7 or 9i and [Quoted] improve both your working environment and your resume.

Daniel A. Morgan Received on Tue Jul 17 2001 - 20:14:02 CEST