You probably have a loop somewhere which open DB statements or connections which are not properly garbage collected. I had a similar problem. I was doing a performance test and created a Java class which read a table with 126 columns and approx. 60.000 records. It then wrote the table record for record in another database. My iteration procedure instantiated a PreparedStatement every iteration. This meant that while running the query the db2 java daemon grew in memory usage from 4.000kb to approximately 50.000 kb in a matter of a minute or so. I did some code tidying making sure that objects are not instantiated unneccessarily and it made the query perform much faster and kept the memory usage stable. I believe you are facing the same problem. I think you must dive into the code and optimize it. Can you post an exmple?
Grtz Michael -----Oorspronkelijk bericht----- Van: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]] Namens JOSHY MON M C Verzonden: woensdag 10 juli 2002 16:57 Aan: [EMAIL PROTECTED] Onderwerp: 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
