Reports running slow on Oracle Application Server 10g

[Ahmad Mujeeb]

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

[Zishan Ali]

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.