Home » RDBMS Server » Performance Tuning » Report hangs (ORACLE 10.2.0.4.0, WINDOWS 2003 SERVER SP2)
Report hangs [message #337583] Thu, 31 July 2008 05:40 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi Friends,


In one of our production database, when we try to run a report through application. The screen didn't generate the output, the report hangs.

What are the things i have to check to identify what is the problem with the database and why it doesn't generate the report.

There is no problem with the query used in that report because that report works good in our test environment.

Thanks in Advance,
Seenu
Re: Report hangs [message #337654 is a reply to message #337583] Thu, 31 July 2008 08:57 Go to previous message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>There is no problem with the query used in that report because that report works good in our test environment
What is different between test & Production, because obviously something is not the same?
Previous Topic: Performance issues after Database Hang during backup
Next Topic: Adding INDEX_DESC hint slow down the query
Goto Forum:
  


Current Time: Mon Dec 05 09:11:26 CST 2016

Total time taken to generate the page: 0.08648 seconds