Hi Neyman, Thanks for your quick response. I use connection pool. Initially it makes 25 connection objects and put in the pool and they are reused. Not closed. But I close prep statements and resultset after using it, but to no avail. Any idea? Thanks Joshy
-----Original Message----- Sent: Wednesday, July 31, 2002 10:04 PM To: Multiple recipients of list ORACLE-L Most probably, it's not Oracle, it's your application, that does not allow oracle to release memory. Are you closing your connections properly? Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 11:33 AM > Hi All, > > Can anyone help me. This is very urgent. > > I have a ticker application written in Java, that accesses oracle 9i > database in Linux. It gets data from database in every 2 minutes. When as > many as 10 ticker clients are accessing database together for 30 minutes, > oracle eventually dies. > > Ticker gets data from database thru Tomcat, on examination I found that each > time memory utilization for Oracle increases with database access. It starts > with 5% mem utilizations and increases - in every 2 minutes - 6%, 7% etc, > for each database access from clients. When it reaches some 30% oracle slows > down and ticker apllication also slows down. > > Does anyone of you have a quick solution - Also why oracle not relasing > memory after database access ? > > Thanks in Advance > Joshy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: JOSHY MON M C > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOSHY MON M C INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).