Home -> Usenet -> comp.databases.oracle -> Memory Usage

Memory Usage

From: Marc Perry <marc.perry03_at_cox.net>
Date: 13 May 2003 08:36:05 -0700
Message-ID: <c937c2f9.0305130736.23905291_at_posting.google.com> 






I am a software developer and I have written a program that uses
Oracle for its data source. I have about 600 users on it and it is
running out of memory. I watched in Enterprise Manager to see what the
memory usage for each user was. The interesting thing I found out was
that when a recordset was closed from the application the memory was
still being taken up by the server. I tried both server side and
client side cursors and had the same result. Has anyone had a similar
problem? I really do not want the app to close the connection and
re-open every hour to free up the memory.
Received on Tue May 13 2003 - 17:36:05 CEST












Original text of this message