Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 9 Vote(s) - 2.78 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reports running slow on Oracle Application Server 10g
#1
AOA,
Dear All,
I have Oracle Application Server installed on windows server 2003 32 bit. Suddenly the reports started to run slow on application server. Kindly guide what parameters to check to resolve this issue.


Regards
Reply
Thanks given by:
#2
There could me multiple reasons.
You should follow the following scenarios.

1. Scenario 1: check if report slow is only occur in one report or all. If only one report is getting slow that means now the data required for that report need more or different indexes on tables. If indexes are fine according to report query that means you should do the restructuring and statistics gather on schema and data dictionary level and increase the sort area size too.


2. Scenario 2: if all the reports are running slow that means now you have to increase the sga. In your case u can only increase sga upto 2 gb, so it is better to upgrade your db from 32 bit to 64 bit.
Further more in this scenario, when you upgrade db to 64 bit you better upgrade application server to 64 bit too and according to oracle application server version family there is no 64 bit version of app server 10g. If you upgrade it to 64bit you have to go to Oracle Weblogic server.


The scenario 2 required lot more R&D so i think you should try scenario 1 or atleast increase sga, it will give u quick impact. But later on after few months or year you must go for scenario 2.
Reply
Thanks given by:




Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!