Re: Locks won't go away in V 7

Roderick Manalac (rmanalac_at_oracle.com) wrote:
: 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';
Sorry, typo on my part. That was what I typed in. All locks below the exclusive 11 were able to be deleted using that command.

: |> 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?

ps -ef describes it as:
oracleSID1 T:I,4096,5

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

It's 7.0.15.

: Roderick Manalac
: Oracle Corporation

Thanks...

Dean Received on Thu Oct 20 1994 - 18:13:04 CET