Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Performance Issues
Performance Issues [message #349074] Thu, 18 September 2008 15:54
Messages: 1
Registered: September 2008
Junior Member

Am not sure if I should be posting my query in this forum, but I'll do it nonetheless.

We recently built an Oracle 10g( Test Database based on our existing 9i( production database. The Oracle Forms ( application is deployed via the Oracle Application Server and connects to the 9i production database. This setup works perfectly well. However, when we recompiled the forms against the Test 10G database and deployed them via the Application server, we found significant sql performance issues when the application was run in the 10g database. Before this, we had regenerated schema statistics in the 10g database using DBMS_STATS. What is all the more strange is that when the problem causing queries in Forms are run in SQLPLUS, they execute with significantly less cost and time.

To summarize, we have inconsistent costs and execution times for the same queries when run from Oracle Forms+App Server and when run from SQLPLUS. Any thoughts, suggestions, advice will be greatly appreciated.

Previous Topic: Forms and Reports Services
Goto Forum:

Current Time: Thu Aug 17 06:53:29 CDT 2017

Total time taken to generate the page: 0.12697 seconds