Home > IT Answers > Oracle > Reports Are Hanging in Oracle 10g
Gopibuchi
5 pts.
 Reports Are Hanging in Oracle 10g
Oracle 10g, Oracle Reports, Oracle Reports 10g, Windows Server 2003
When Iam Opening Repots Some Reports Are Hanging Due To Heavy Coding ,At The Same Time When I Started To Run A Simple  new Reports That Is Also Hanging  What Is The Problem ,And Give Me Solution.

Software/Hardware used:
oracle 10g,windows-2003
ASKED: September 17, 2009  6:35 AM
UPDATED: January 27, 2011  8:38 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I don’t think it is normal that a report hangs due to “heavy coding”. If you have identified the reports that cause the problems, you should review their code carefully, and correct any errors they could have.

carlosdl
 63,535 pts.
 

Have you checked your .CONF file in ORA_HOME1reportsconf?

You may have to change your MAXENGINE values. Sounds like issues we were having. Also log into your Application Server Console and look in the REPORTS_SERVER_REP in the CURRENT JOBS and FAILED JOBS links. It will tell you more information about the reports. I would start there first.

jkeri
 340 pts.