Hanging Process Server - Peolpesoft 8

Processes are currently hanging and we need to find out which job is hung.
 
First, which table at the db layer houses all running processes - prcs?  Follow on - can we just delete the corersponding record?

Second, how do you restart the process server and/or are there reference guides to find the appropriate restart path on a unix box?
LVL 1
gNomeAsked:
Who is Participating?
 
schwertnerCommented:
Use v$session view from SQL*Plus to see the Oracle processes.
also the Unix/Linux
top
command can show you the resources used by different processes.
In Oracle yocan 'kill' sessions

details here:
http://www.oracle-base.com/articles/misc/KillingOracleSessions.php

use IMMEDIATE option.

They main problem is to find the needed session.
Killing processes in Unix is not good.
0
 
gNomeAuthor Commented:
For the first question I meant :
Can we delete the record for the job that it is hanging on and if so which table would that entry live in?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.