Re: Lock on table

From: AJ Benn <a.j.benn_at_x400.icl.co.uk>
Date: Wed, 30 Sep 1998 16:47:55 +0100
Message-ID: <3612516e.0@145.227.194.253>

It's PMON that monitors the users processes, and if a process is killed off in the middle of a transaction, PMON will assume the identity of the user and perform a rollback of the aborted transaction. It is also responsible for releasing any locks or other system resources held by the failed process. May be you need to look at tuning PMON rather than SMON.

Andy

Luc Demanche wrote in message <01bdeaf6$b700a890$100d13cc_at_oracle>...
>A user lock a row in a table. His PC crashed and the lock still on table.
>The SMON process will run to destroy the connexion, but what does happen
>with the lock on row. Can we increase the frequence of SMON.
>
> Thanks
> Luc Demanche
> demanchel_at_icotech.com
Received on Wed Sep 30 1998 - 10:47:55 CDT