I had similar problem in old application. It was cause I wasnt closing resultsets and statements. Also make sure you are closing connections. -Tim
-----Original Message----- From: JOSHY MON M C [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:57 AM To: [EMAIL PROTECTED] Subject: Help - Tomcat oracle : offtopic 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 =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
