Constantly increasing process memory consumption

From: Skurský Michal <skursky_at_brn.pvt.cz>
Date: Fri, 13 Apr 2001 01:02:01 -0700
Message-ID: <F001.002E8F1E.20010413002521@fatcity.com>

   I would like to ask somebody who is experienced with PRO*C on Alpha OpenVMS.
I have created process, which is connected to the database and constantly going.
But his PGA is constantly increasing. On Metalink I have found advice to use kompile parameter (in file pcscfg.cfg) RELEASE_CURSOR=YES.
Is there any other advice, experience or theoretical explanation?

Thanks
Michal Skursky

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?ISO-8859-2?Q?Skursk=FD_Michal?=   INET: skursky_at_brn.pvt.cz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 13 2001 - 03:02:01 CDT