Re: Memory Usage
Date: Tue, 13 May 2003 11:39:04 -0500
Message-ID: <jp72cvke63iflc68fbnjfbeq829gs6of5v_at_4ax.com>
marc.perry03_at_cox.net (Marc Perry) wrote:
>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.
If you do not want to close the connection ( which, IMHO, is the best approach) then look into using
MTS to set up shared dispatchers for connecting..That way many users can share the same connection and you can set memory
aside outside of the 'normal' SGA area for their session memory...
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Tue May 13 2003 - 18:39:04 CEST