i think you.d better to use a connection pool . ----- Original Message ----- From: "JOSHY MON M C" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 11:57 PM 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
