Re: Lock Monitoring question

From: Balakrishnan Subramanian <bala.subramanian_at_mci.com>
Date: 1997/06/20
Message-ID: <33AAC67C.D83C4D8B@mci.com>#1/1

It is rollback segment lock.

Bala.

Nandan Shah wrote:
>
> while monitoring locks on a 7.3.3 database i noticed that - when i
> execute a statement "update dept where dept_id = 1" and one record gets
> updated the lock monitor in Server Manager shows two lines . I gathered
> that one is a Row Exclusive Lock on the dept table and the other is a
> Exclusive Lock. Does anybody know what the second line is all about?
>
> Nandan Shah
> Cambridge Technology Partners
> nshah_at_ctp.com
Received on Fri Jun 20 1997 - 00:00:00 CDT