Slow processing from web production server

[cleanair4me]

I have a JSP that works with an Oracle 9i database.

On my local windows workstation where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server connecting to the same Schema processes very slowly 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?

 

[SantaMufasa]

CleanAir,

Do you have Oracle Enterprise Manager running? If so, you can navigate to/click on the Performance menu/tab and see the Load Average, Active Sessions, Disk I/O, and Throughput. Those values appear as graphs for the last n period of time and can graphically describe the behaviour of your instance.

Without those findings, it will be rather difficult to give you more than just shots in the dark for assistance.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.

 

[cleanair4me]

Thanks,

I do have OEM. I assume I will look at the Performance tool you mentioned while the JSP is working with Oracle on my slow Production server.
Not sure what I am looking for but I will let you know what I find.