Re: Nuts and bolts about locking...

From: Chris Kasten <kasten_at_brookings.net>
Date: 1995/11/29
Message-ID: <49hvgn$cuh_at_news.corpcomm.net>#1/1


wcurtis_at_mindspring.com (William Curtis) wrote:

> Can anyone give an indepth explanation of exclusive row locking, rollback
> segments and slots, latches that are acquired. The resource ID 1&2 refer
> to a rollback segment and slot. When a second resource is attempting to
> modify that same row, why does SQL*DBA indicated contention on the
> resource ID 1& 2 (rollback segment & slot information?)
 

> Thanks in advance,
 

> William
> wcurtis_at_mindspring.com

For what its worth, I believe that resource ID 1 (in v$locks) refers to the dba_objects (ie the table name)...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Wed Nov 29 1995 - 00:00:00 CET

Original text of this message