Oracle Memory leakage

From: Rok Kodrun <rok.kodrun_at_uni-lj.si>
Date: Tue, 17 Jul 2001 11:23:23 +0200
Message-ID: <9j106c$ebl$1@goodnews.ijs.si>

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 Received on Tue Jul 17 2001 - 04:23:23 CDT