I have a JSP that works with an Oracle 9i database.
On my local windows workstation (using Tomcat) where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server (Tomcat) connecting to the same Schema processes very slow many times during the day.
There is only one user for the application and I dont understand why the same application using the same database runs so much slower on the production server compared to my local workstation.
Please advise?