Did you insert the numbers into the SQL statement your having a problem with to shorten it and have value substitutes?
Top of my head - you didn't say if you altered the SQL posted so I'm guessing you did. sounds like you have a oracle tuning problem. In the database itself or connection pooling/cache. Areas I would focus on at first. You may not be getting past splash screen in browser because the process is hanging without sending back the actual http redirection but simultaneously executing a servlet. You should monitor HTTP headers with a tool like wireshark and send them back to the list or PTC as well as monitor both Tomcat, Apache, and log4j logs to get as much verbosity about connections and requests.
PTC probably would want to see all of your properties.