aurora does not free unused memory

From: Marco Poetke <marco_at_dbs.informatik.uni-muenchen.de>
Date: 2000/05/19
Message-ID: <3924FD74.F82A8D5F@dbs.informatik.uni-muenchen.de>#1/1

Hi all,

I am running 8.1.6 on NT4. When I call memory intensive Java Stored Procedures within a PL/SQL call, the PGA increases rapidly and after some 100MBs I get a Java OutOfMemoryError.

Could it be that the Aurora Garbage Collector does not free unused memory within a PL/SQL call?

A call to dbms_session.free_unused_user_memory does only work AFTER the PL/SQL call has been finished.

Has anybody an idea how to free unused java memory within a PL/SQL call?

Thank for helping,

Marco. Received on Fri May 19 2000 - 00:00:00 CDT