Hanging Report Requests In UNIX

Asked By hj.Eleanor 0 points N/A Posted on - 07/22/2016

Often when duplicate processes run simultaneously in a UNIX system report requests from report servers hang up and can lead to serious performance issues. What can be a workaround this process?

• Status: Open
• Question Views: 347
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Unix Networking

Answered By saad kalwar 10 points N/A #104249

Hanging Report Requests In UNIX

Report request crashes are based majorly on two issues. Either the master job hangs up or freezes before finishing or report server stops responding when running report requests. We may approach the problems as follows:

a) Master Job hangs: To start with we must check the engineResponseTimeOut in the engine element of rwserver.conf file, from here we can set all attributes to prevent server instability. We can also try showjobs command on the console to know which jobs are hanging up, by ending the hanging processes we can enable other processes in the priority queue to run.

b) Report server stops responding: We can try restarting the report server and if that does not work or is not possible we can get the dump for debugging by killing the current process and getting the dump to a separate file. On Solaris the command “kill -3 server_pid” provides the required diagnostic information on the console. To redirect the thread information we can modify the rwserver.sh file in $ORACLE_INSTANCE/config/reports/bin directory.

About saad kalwar

Questions
39

Answers
28

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 07/22/2016
• Question Category: Unix Networking