Re: Oracle Memory leakage

"Rok Kodrun" <rok.kodrun_at_uni-lj.si> wrote in message news:9j106c$ebl$1_at_goodnews.ijs.si...
> 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
>
>
>
>

Using 64 Mb for any Oracle database is just ridiculous.

Upgrade to 256 Mb at least

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Jul 17 2001 - 11:44:15 CDT