oracle hanging sessions, v$process, v$sessions, help!

this is a follow up post to my problems about oracle/novell sessions hanging.

whenever a user gets disconnected (machine crashed), the session in oracle stays. doing a select * from v$session indicates that the session is still there, INACTIVE status. doing a select from v$process indicates that the process is still there (matching the PADDR field in v$session to the ADDR field in v$process).

now I issue an alter system kill ... command.

selecting from v$session indicates the session status to be KILLED, the SERVER field returns PSEUDO. selecting from v$process shows a program running called PSEUDO.

and at this point, there is no way to get rid of that killed session and the novell processes other than to shut down oracle!!

is there a way out of this ? these hung sessions eat up a lot of resources.

please email replies if possible.
thanks in advance.

jerry Received on Thu Oct 20 1994 - 23:42:25 CET