Dan - I'd look into why Oracle took an "improper" index (whatever that means). There is nothing in Tomcat/JDK that would mess with your queries that I'm aware of. I'd also investigate all the standard reasons why Oracle recomputes explain plans for queries - most of which are related to the query. Are all your varying values passed via bind variables? What are your DBs optimization settings? Stuff like that. Otherwise, the question is probably better presented on an Oracle forum. Jeff
-----Original Message----- From: Dan Denton [mailto:dden...@remitpro.com] Sent: Tuesday, January 26, 2010 11:41 AM To: users@tomcat.apache.org Subject: Tomcat/JDBC Thin Client and Oracle SQL Parsing Hello all. Several days ago we saw some strange behavior with an Oracle database after the restart of a tomcat webapp. Immediately after restart, Oracle was processing the query for a certain page using an improper index that caused the page/query to hang. We've taken a look at the configuration for our CBO and come to the conclusion that Oracle should not have reparsed the query unless the query were somehow different, but we can't find anything to indicate the query changed. While it's possible there's something we missed, I would like to know if anyone out there knows why a webapp restart would cause the database to reparse and choose a new execution plan. We're running Tomcat 5.5.12 with JDK 1.5.0_12. This is on an RHEL4 server running a 2.6.9 kernel. The tomcat instance is using a JDBC thin client to connect to the database. I know of no queries that are made to the database immediately upon startup, and it's certainly not this one since the query is page specific. Can anyone point out any instances they've had where Tomcat or Tomcat with the Oracle JDBC driver has exhibited similar behavior? Many thanks in advance, Dan ******************************* NOTICE ********************************* This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (call us collect at 512-343-9100) and immediately delete this message and all its attachments. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
