Re: Locks won't go away in V 7

dwittke_at_trumpet.aix.calpoly.edu (Dean Wittke) writes:
|> mon lock shows a few processes waiting for PID 11, Serial# 11168.
|> WHen I try to alter system kill session (11, 11168) I get this
|> error:
|> ORA-00026 - Missing or invalid session ID
I believe the correct syntax would be -
ALTER SYSTEM KILL SESSION '11, 11168';
|> When I get the AIX system process number from
|> mon process
|> and kill it, something restarts a new process with another
|> system process number.
|> How can I clean up this deadlock?
What is the name of the process you are killing?

|> We have Oracle 7.0 running on a RS6000.
The third set of numbers is sometimes important to know too.

Roderick Manalac
Oracle Corporation Received on Thu Oct 20 1994 - 04:25:27 CET