Oracle 9i, tomcat

From: JOSHY MON M C <JOSHYMON_at_nestec.net>
Date: Wed, 31 Jul 2002 07:33:24 -0800
Message-ID: <F001.004A7663.20020731073324@fatcity.com>

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: JOSHYMON_at_nestec.net

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 Wed Jul 31 2002 - 10:33:24 CDT